Oracle

From Richard's Wiki
Revision as of 23:56, 23 February 2009 by Rkdrm (Talk | contribs) (New page: == SQLPlus == * To see your tables, type: SELECT TABLE_NAME FROM USER_TABLES; * To see tables owned by everyone, type: SELECT OWNER, TABLE_NAME FROM ALL_TABLES;)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

SQLPlus

  • To see your tables, type:
SELECT TABLE_NAME FROM USER_TABLES;
  • To see tables owned by everyone, type:
SELECT OWNER, TABLE_NAME FROM ALL_TABLES;