Oracle查询表的所有字段、类型及备注 原创

Oracle查询表的所有字段、类型及备注

SELECT tc.column_name,
case
when tc.DATA_TYPE = 'VARCHAR2'
then tc.DATA_TYPE || '(' || tc.DATA_LENGTH || ')'
else tc.DATA_TYPE
end as "type",
cc.comments,
tc.data_type,
tc.data_length,
tc.owner
FROM all_tab_columns tc
JOIN
all_col_comments cc
ON tc.owner = cc.owner
AND tc.table_name = cc.table_name
AND tc.column_name = cc.column_name
WHERE 1 = 1
and tc.owner = 'GCS_SJJY' -- YOUR_SCHEMA_NAME
AND tc.table_name = 'TSS_AKM'; --YOUR_TABLE_NAME