oracle的describe,[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