Oracle 生成数据字典

bz85eh9314

SELECT  ROWNUM 序号,A.COLUMN_NAME AS "字段名称",B.comments AS "字段描述",
A.DATA_TYPE as 字段类型,
REPLACE(DECODE(A.CHAR_LENGTH,0,DECODE(A.DATA_SCALE,NULL,A.DATA_TYPE,A.DATA_PRECISION||','||A.DATA_SCALE),A.CHAR_LENGTH),',0','') 字段长度,
REPLACE(REPLACE(A.NULLABLE,'Y','√'),'N','') AS "能否为空",
A.DATA_DEFAULT AS "默认值"
FROM sys.all_tab_columns A,sys.DBA_COL_COMMENTS B
WHERE A.owner=B.owner AND A.table_name=B.table_name  AND A.COLUMN_NAME=B.COLUMN_NAME AND A.owner='用户名'  AND
A.TABLE_NAME IN (
'TB_MT_CONVENIENCE_APP'
)
ORDER BY A.TABLE_NAME