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.