废话不多说,直接在PLSQL控制台 运行SQL即可
SELECT t.table_name table_name,
t.comments table_comments,
t1.column_name column_name,
t2.DATA_TYPE || '(' || t2.DATA_LENGTH || ')' date_type,
t1.COMMENTS column_comments
FROM user_tab_comments t, User_Col_Comments t1, User_Tab_Cols t2
WHERE t.table_name = t1.table_name
AND t2.column_name = t1.column_name
AND t2.table_name = t1.table_name
AND t.table_name not like '%$%'; --加条件,限制不需要导出的表结构