--- 数据字典表:desc dictionary;
SQL> desc dictionary;
Name Type Nullable Default Comments
---------- -------------- -------- ------- --------------------------
TABLE_NAME VARCHAR2(30) Y Name of the object
COMMENTS VARCHAR2(4000) Y Text comment on the object
---查看表结构
desc 表名;
如:desc dept;
SQL> desc dept;
Name Type Nullable Default Comments
------ ------------ -------- ------- --------
DEPTNO NUMBER(2)
DNAME VARCHAR2(14) Y
LOC VARCHAR2(13) Y