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