1.执行该语句，是所有的数据库表结构

SELECT t3.comments       AS "表注释",
t1.Table_Name       AS "表名称",     
       t1.Column_Name                                AS "字段名称",
       t1.DATA_TYPE || '(' || 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
  LEFT JOIN user_objects t4 
         ON t1.table_name = t4.OBJECT_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 in ('QY_ORG'
            --可以注释掉上面这句
            )        
  ORDER BY t1.Table_Name, t1.Column_ID; 

2.导出表结构即可执行结构如下：

image.png