SELECT
t1.Column_Name AS "字段名称",
t1.Data_Type AS "数据类型",
t1.Data_Length AS "长度",
t1.NullAble AS "是否为空",
t2.COMMENTS AS "字段说明",
t1.Data_Default "默认值"
FROM dba_tab_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_COL_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 )
and t1.TABLE_NAME = 'table_test'
ORDER BY t1.Table_Name, t1.Column_ID;
oracle数据表结构导出到word方法
最新推荐文章于 2024-06-15 09:40:51 发布