查询数据字典中字段的相关信息

SELECTT .column_name AS column_name, --列名T .column_type AS column_type, ---字段类型T .data_length AS data_length, --字段长度T .data_scale AS data_scale, --字段精度T .column_comment AS column_comment, --字段注释case when substr(b.constraint_type,1,1)=‘P‘ then ‘N‘ else null end as Is_PrimaryKey, --是否主键DECODE(T.nullable,‘N‘,T.nullable,NULL) nullable –是否为空FROM(SELECTUB.tablespace_name AS database_name,UTC.table_name AS table_name,UTC.column_name AS column_name,UTC.data_length AS data_length,UTC.data_type AS column_type,utc.data_scale AS data_scale,ucc.comments AS column_comment,utc.column_id,utc.nullableFROMuser_tables ubLEFT JOIN user_tab_columns utc ON ub.table_name = UTC.table_nameLEFT JOIN user_col_comments ucc ON utc.column_name = ucc.column_nameAND utc.table_name = ucc.table_name) TLEFT JOIN (SELECTUCC.table_name AS table_name,ucc.column_name AS column_name,wm_concat (UC.constraint_type) AS constraint_typeFROMuser_cons_columns uccLEFT JOIN user_constraints uc ON UCC.constraint_name = UC.constraint_nameGROUP BYUCC.table_name,ucc.column_name) b ON T .table_name = b.TABLE_NAMEAND T .column_name = b.column_namewhere T.table_name=‘T0_CFG‘ order by T.column_id