替换#TABLE_NAME和#OWNER为要查询的表和模式

SELECT
	AA.COLUMN_NAME 列名,
	AA.DATA_TYPE 字段类型,
	SS.COMMENTS 描述,
	AA.DATA_LENGTH 类型长度,
	AA.DATA_PRECISION 整数位,
	AA.DATA_SCALE 小数位,
	(CASE WHEN (AA.NULLABLE = 'N') THEN 'YES' ELSE 'NO' END) 是否非空,
	BB.CONSTRAINT_NAME 主键约束名,
	CC.DATA_DEFAULT 默认值
FROM ALL_TAB_COLUMNS AA
	INNER JOIN ALL_COL_COMMENTS SS
	ON SS.COLUMN_NAME = AA.COLUMN_NAME AND SS.TABLE_NAME = AA.TABLE_NAME
	LEFT JOIN ALL_CONS_COLUMNS BB
	ON BB.COLUMN_NAME = AA.COLUMN_NAME AND BB.TABLE_NAME = AA.TABLE_NAME
	LEFT JOIN DBA_TAB_COLUMNS CC
	ON CC.COLUMN_NAME = AA.COLUMN_NAME AND CC.TABLE_NAME = AA.TABLE_NAME
WHERE AA.TABLE_NAME = '#TABLE_NAME' AND AA.OWNER = '#OWNER'
ORDER BY AA.COLUMN_ID;