oracle 导出表结构到excel文件

以下使用工具PL/SQL导出,直接可用,改一下table_name in 那里添加一下自己想要筛选的数据表就行了,如果想导出全部直接把那个筛选语句去掉就行了

SELECT t3.comments       AS "表注释",
t1.Table_Name       AS "表名称",     
       t1.Column_Name                                AS "字段名称",
       t1.DATA_TYPE || '(' || t1.DATA_LENGTH || ')'  AS "数据类型",
       t1.NullAble                                   AS "是否为空",
       t2.Comments                                   AS "字段注释",
       t1.Data_Default "默认值"
  FROM cols t1
  LEFT JOIN user_col_comments t2 
         ON t1.Table_name = t2.Table_name
        AND t1.Column_Name = t2.Column_Name
  LEFT JOIN user_tab_comments t3 
         ON t1.Table_name = t3.Table_name
  LEFT JOIN user_objects t4 
         ON t1.table_name = t4.OBJECT_NAME
  WHERE NOT EXISTS (SELECT t4.Object_Name
          FROM User_objects t4
         WHERE t4.Object_Type = 'TABLE' 
         
           AND t4.Temporary = 'Y'
           AND t4.Object_Name = t1.Table_Name)
           and t1.Table_Name in ('T_B_LINE_LIST','T_B_LINE_DEPART','T_B_EQUIPMENT','T_B_TOWER','T_B_HIDDEN_EQUIPMENT','T_B_HIDDEN_LIBRARY','T_B_HIDDEN_LIBRARY_DETAILS','T_B_HIDDEN_LIBRARY_ATTACHMENT','T_B_HIDDEN_LIBRARY_OVERDUE','T_B_HIDDEN_RISK_CHANGE','T_B_TASK','T_B_TASK_PART_USER','T_B_TASK_CAR','T_B_TASK_BASE_INFO','T_B_TASK_TAG','T_B_TASK_SYNC_LOG','T_B_TASK_USER_POINT','T_B_TASK_USER_TAG'
            --可以注释掉上面这句
            )        
  ORDER BY t1.Table_Name, t1.Column_ID; 

然后plsql
右键生成excel文件

然后…大功告成~~~
最近写文件写的怀疑人生,什么狗屁代码文档,接口文档,数据库说明,最后告诫大家,写代码不注释的都是狗,文档都没有就交接给我,要我命~~~~
卧槽,下班了,溜了溜了~~~~