Slide 14.3: Using SQL*Plus: the Oracle interface (cont.)
  Slide 14.5: Introduction to SQL
  Home


Using SQL*Plus: the Oracle Interface (Cont.)


exit
Commits or rolls back all pending changes, logs out of Oracle, terminates SQL*Plus and returns control to the operating system.

describe [ object ]
DESCRIBE lists the column definitions of a table.
   SQL> describe customers
   Name                    Null?     Type
   ----------------------- --------  -----------------
   NAME                              VARCHAR2(32)
   SSN                     NOT NULL  CHAR(10)
   NO                                NUMBER(38)
user_tables
It contains the information of tables owned by the users.
   SQL> select table_name from user_tables;
   TABLE_NAME                     
   ------------------------ 
   CUSTOMERS
   GAMES
all_tables
It contains the information of tables owned by the system.
   SQL> select table_name from all_tables;
   TABLE_NAME
   ------------------------
   ...
clear option
Resets or erases the current value or setting for the specified option. For example,
   SQL> clear screen
pause [ text ]
Displays the specified text then waits for the user to press RETURN.