Slide 11.3: Using SQL*Plus: the Oracle interface (cont.)
Slide 11.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.