oracle 表字段以及字段注释、类型信息获取

﹏ヽ暗。殇╰゛Y 2022-01-28 03:09 452阅读 0赞

SELECT DISTINCT
*
FROM
(
SELECT
comments AS “Name”,
a.column_name “Code”,
a.DATA_TYPE AS “DataType”,
b.comments AS “Comment”,
DECODE( c.column_name, NULL, ‘FALSE’, ‘TRUE’ ) AS “Primary”,
DECODE( a.NULLABLE, ‘N’, ‘TRUE’, ‘Y’, ‘FALSE’, ‘’ ) AS “Mandatory”
FROM
all_tab_columns a,
all_col_comments b,
(
SELECT
a.constraint_name,
a.column_name
FROM
user_cons_columns a,
user_constraints
WHERE
a.constraint_name = b.constraint_name
AND b.constraint_type = ‘P’
AND a.table_name = upper( ‘sys_config’ )
) c
WHERE
a.Table_Name = b.table_Name
AND a.column_name = b.column_name
AND a.Table_Name = upper( ‘sys_config’ )
AND a.COLUMN_NAME = c.column_name ( + )
ORDER BY
a.COLUMN_ID
)

发表评论

表情：
评论列表 （有 0 条评论，452人围观）

还没有评论，来说两句吧...

相关阅读