Oracle中的表结构导出到word
SELECT t1.table_name AS "表名称",
t3.comments AS "表说明",
t1.column_name AS "字段名称",
t1.data_type AS "数据类型",
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
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)
ORDER BY t1.table_name, t1.column_id;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25444422/viewspace-2091023/ ，如需转载，请注明出处，否则将追究法律责任。
