sql语句和oracle语句的结构,怎么用sql语句查询表的结构

SQL code--这样能否满足你的需求

SELECT COLUMN_NAME, DATA_TYPE, COMMENTS, KEY, wm_concat(index_name) index_name, NULLABLE

FROM (SELECT A.COLUMN_NAME,

decode(A.DATA_TYPE,

'CHAR',

A.DATA_TYPE || '(' || A.DATA_LENGTH || ')',

'DATE',

A.DATA_TYPE,

'NUMBER',

A.DATA_TYPE,

'VARCHAR2',

A.DATA_TYPE || '(' || A.DATA_LENGTH || ')') AS DATA_TYPE,

B.comments,

decode(C.COLUMN_NAME, NULL, 'No', 'Yes') AS Key,

d.index_name,

decode(A.NULLABLE, 'N', 'NOT NULL', 'Y', 'NULL') AS NULLABLE

FROM sys.user_tab_cols A,

sys.user_col_comments B,

(SELECT col.column_name, c.table_name

FROM user_constraints c, user_cons_columns col

WHERE c.constraint_name = col.constraint_name AND

c.constraint_type = 'P') C,

user_ind_columns d

WHERE upper(A.TABLE_NAME) = '表名' AND

A.TABLE_NAME = B.table_name AND

A.COLUMN_NAME = B.column_name AND

A.Table_Name = C.TABLE_NAME(+) AND

A.COLUMN_NAME = C.COLUMN_NAME(+) AND

b.column_name = d.column_name(+))

GROUP BY COLUMN_NAME, DATA_TYPE, COMMENTS, KEY, NULLABLE;