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;
oracle 如何导出表名、字段定义、字段注释
最新推荐文章于 2024-08-22 08:46:19 发布