oracle 如何导出表名、字段定义、字段注释

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版权协议,转载请附上原文出处链接和本声明。