Oracle导出当前用户下的所有表结构（包含它的详细信息）

导入表结构

第一步：用PLSQL在工具栏—导入表导入此代码文档

SPOOL "你保存的路径.txt"
SELECT t1.table_name AS "表名称",
       NVL(t3.comments,'NaN') AS "表说明",
       t1.column_name AS "列名",
       NVL(t2.comments, 'NaN') AS "列说明",
       t1.data_type AS "数据类型",
       CASE WHEN t4.temporary = 'Y' THEN '是' ELSE '否' END AS "是否临时表"
FROM user_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_tab_comments t3 ON t1.table_name = t3.table_name
LEFT JOIN user_tables t4 ON t1.table_name = t4.table_name
WHERE NOT EXISTS (
    SELECT object_name FROM user_objects WHERE object_type = 'TABLE' AND temporary = 'Y' AND object_name=t1.table_name
)
ORDER BY t1.table_name, t1.column_id;

SPOOL OFF