Oracle 返回字段名称数据类型字段说明

最新推荐文章于 2025-02-05 13:53:36 发布

原创最新推荐文章于 2025-02-05 13:53:36 发布 · 625 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle

Oracle 专栏收录该内容

6 篇文章

订阅专栏

该SQL查询用于获取Oracle数据库中'AGREEMENT_RECORD'表的详细信息，包括表名称、字段名、数据类型及字段说明。查询结果按表名和字段ID排序，排除临时表。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SELECT 
       --t1.Table_Name || chr(13) || t3.comments       AS "表名称及说明",
       t1.Column_Name                                AS "字段名称",
       t1.DATA_TYPE||'('|| t1.DATA_LENGTH ||')'     AS "数据类型",
       --t1.NullAble                                   AS "是否为空",
       t2.Comments                                   AS "字段说明"
       --t1.Data_Default                               AS "默认值"
       --t4.created                                  AS "建表时间"
       --t3.comments                                 AS "表说明"
  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='AGREEMENT_RECORD'
  ORDER BY t1.Table_Name, t1.Column_ID;