SELECT C.COMMENTS "表注释",
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 "字段类型",
A.DATA_DEFAULT AS "默认值",
A.NULLABLE AS "能否为空",
B.COMMENTS AS "备注"
FROM SYS.USER_TAB_COLUMNS A, SYS.USER_COL_COMMENTS B, USER_TAB_COMMENTS C
WHERE A.TABLE_NAME = B.TABLE_NAME
AND A.COLUMN_NAME = B.COLUMN_NAME
AND A.TABLE_NAME = C.TABLE_NAME
ORDER BY A.TABLE_NAME
查表结构 Oracle
于 2021-08-28 16:44:57 首次发布