摘要:
-- 查询某表的数据字典SELECT A.TABLE_NAME AS "表名",A.COLUMN_NAME AS "字段名",DECODE(A.CHAR_LENGTH,0,DECODE(A.DATA_SCALE,NULL,A.DATA_TYPE,A.DATA_TYPE||'('||A.DATA_PRECISION||','||A.DATA_SCALE||')'),A.DATA_TYPE||'('||A.CHAR_LENGTH||')') as "字段类型1" 阅读全文