日期:2014-05-16  浏览次数:20468 次

oracle查数据表结构与注释

SELECT t.table_name as 表名,
?????? t.colUMN_NAME as 字段名称,
?????? t.DATA_TYPE || '(' || t.DATA_LENGTH || ')' as 字段类型,
?????? t1.COMMENTS as 字段说明
? FROM User_Tab_Cols t, User_Col_Comments t1
WHERE t.table_name = t1.table_name
??? AND t.column_name = t1.column_name
??? AND T.table_name = 'ZZJLOG'