查询表名及字段信息数据

SELECT
	A.TABLE_NAME 表名,
	A.COLUMN_NAME 字段名,
	A.COMMENTS 字段注释,
	B.DATA_TYPE 字段类型,
	B.DATA_LENGTH 字段长度,
	B.NULLABLE 是否为空,
	C.INDEX_NAME 索引名称 
FROM
	USER_COL_COMMENTS A
	LEFT JOIN USER_TAB_COLUMNS B ON A.COLUMN_NAME = B.COLUMN_NAME 
	AND A.TABLE_NAME = B.TABLE_NAME
	LEFT JOIN USER_IND_COLUMNS C ON A.COLUMN_NAME = C.COLUMN_NAME 
	AND A.TABLE_NAME = C.TABLE_NAME 
WHERE
	A.TABLE_NAME = 'PLM_MAIN' 
ORDER BY
	B.COLUMN_ID