Oracle数据库-实用SQL

1.导出表结构为excel结构文件
SELECT t.colUMN_NAME as 字段英文名,
       t1.COMMENTS as 字段名称,
       t.DATA_TYPE || '(' || t.DATA_LENGTH || ')' as 字段类型，
       '' as 下拉选项,
       '' 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='要导出的table名称';

------------------------------------持续更新----------------------------------