Oracle中的表構造匯出到word Sql語句

標籤：

select * from (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 t2on t1.Table_name=t2.Table_name and t1.Column_Name=t2.Column_Nameleft join user_tab_comments t3 on t1.Table_name=t3.Table_name WHERE NOT EXISTS ( SELECT t4.Object_Name FROM User_objects t4WHERE t4.Object_Type=‘TABLE‘ AND t4.Temporary=‘Y‘ AND t4.Object_Name=t1.Table_Name )ORDER BY t1.Table_Name, t1.Column_ID)k where k."表名稱" = ‘LBSP_EC_REMAPP‘;

Oracle中的表構造匯出到word Sql語句