Difference between revisions of "Oracle"

From Richard's Wiki
Jump to: navigation, search
(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;)
 
 
Line 1: Line 1:
 +
== ODBC ==
 +
* [http://wiki.oracle.com/page/ODBC Oracle ODBC wiki page]
 +
 
== SQLPlus ==
 
== SQLPlus ==
 
* To see your tables, type:
 
* To see your tables, type:

Latest revision as of 20:08, 9 January 2011

ODBC

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;