Difference between revisions of "Oracle"

Revision as of 00:56, 24 February 2009

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;