SELECT c.table_name 英文表名,
t.COMMENTS 中文表名称,
cc.COLUMN_NAME 字段名,
cc.COMMENTS 字段注释,
c.DATA_TYPE || '(' || c.DATA_LENGTH || ')' 字段类型及长度
FROM dba_tab_columns c
LEFT JOIN dba_col_comments cc
ON c.table_name = cc.table_name
AND c.column_name = cc.column_name
LEFT JOIN dba_tab_comments t
ON c.table_name = t.table_name
WHERE c.OWNER = 'SYSADMIN'
AND c.TABLE_NAME LIKE 'T%'
ORDER BY c.table_name;
版权声明:本文为lotusyangjun原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。