SELECT A.TABLE_NAME 表名,A.COLUMN_NAME 字段名,
A.DATA_TYPE 数据类型,
A.DATA_LENGTH 长度,
A.DATA_PRECISION 整数位,
A.DATA_SCALE 小数位,
A.NULLABLE 允许空值,
A.DATA_DEFAULT 缺省值,
B.COMMENTS 备注
FROM USER_TAB_COLUMNS A, USER_COL_COMMENTS B
WHERE A.COLUMN_NAME = B.COLUMN_NAME
AND A.TABLE_NAME = B.TABLE_NAME
ORDER BY A.TABLE_NAME
A.DATA_TYPE 数据类型,
A.DATA_LENGTH 长度,
A.DATA_PRECISION 整数位,
A.DATA_SCALE 小数位,
A.NULLABLE 允许空值,
A.DATA_DEFAULT 缺省值,
B.COMMENTS 备注
FROM USER_TAB_COLUMNS A, USER_COL_COMMENTS B
WHERE A.COLUMN_NAME = B.COLUMN_NAME
AND A.TABLE_NAME = B.TABLE_NAME
ORDER BY A.TABLE_NAME