[Oracle] Oracle中的describe命令

describe命令查看表结构.

[例子]

SQL> create table test (col1 char(1) not null,
  2  col2 varchar2(10),
  3  col3 number(4,2),
  4  col4 blob,
  5  col5 raw(5),
  6  col6 date,
  7  col7 long);

表已创建。

SQL> desc test;
名称                                      是否为空? 类型
----------------------------------------- -------- ---------------------

COL1                                      NOT NULL CHAR(1)
COL2                                               VARCHAR2(10)
COL3                                               NUMBER(4,2)
COL4                                               BLOB
COL5                                               RAW(5)
COL6                                               DATE
COL7                                               LONG