oracle

SELECT a.TABLE_NAME 表名
a.COLUMN_NAME 字段名,
DATA_TYPE ||decode(DATA_TYPE,'DATE','','CLOB','','BLOB','','BFILE','','FLOAT','','LONG RAW','','LONG','','RAW','(' || TO_CHAR(DATA_LENGTH) || ')',
(decode(SIGN(instr(DATA_TYPE, 'CHAR')),1,
'(' || TO_CHAR(DATA_LENGTH) || ')',(decode(SUBSTR(DATA_TYPE, 1, 9),
'TIMESTAMP', '',
(decode(NVL(DATA_PRECISION, -1), -1,
'',(decode(nvl(DATA_SCALE, 0), 0,
'(' || to_char(DATA_PRECISION) || ')', '(' || to_char(DATA_PRECISION) || ',' ||
to_char(DATA_SCALE) || ')'))))))))) 字段类型,
a.NULLABLE 允许为空,
b.comments 字段注释
FROM ALL_TAB_COLUMNS a,
all_col_comments b
WHERE b.table_name=a.TABLE_NAME
and a.OWNER=b.owner
and a.COLUMN_NAME=b.COLUMN_NAME
and a.TABLE_NAME =upper( 'af_staffs')
--AND a.OWNER =upper( 'OUTSIDE_ENTERPRISESTATETAX')
ORDER BY COLUMN_ID;