Miscellaneous SQL*PLUS

Finding Out What Tables You Have.

SQL> select * from user_catalog;

TABLE_NAME		       TABLE_TYPE
------------------------------ -----------
BONUS			       TABLE
DEPT			       TABLE
DUMMY			       TABLE
EMP			       TABLE
S			       TABLE
SALGRADE				TABLE

6 rows selected.

Finding Out About A Specific Table.

SQL> describe
Usage: DESCRIBE [user.]object[.subobject|@db_link] [column]
SQL> describe emp
 Name				 Null?	  Type
 ------------------------------- -------- ----
 EMPNO				 NOT NULL NUMBER(4)
 ENAME					  VARCHAR2(10)
 JOB					  VARCHAR2(9)
 MGR					  NUMBER(4)
 HIREDATE				  DATE
 SAL					  NUMBER(7,2)
 COMM					  NUMBER(7,2)
 DEPTNO 				  NUMBER(2)

Saving your SQL*PLUS Session in a File.

SQL> spool session
.
.
.
SQL> spool off