oracle用sql查询描述表结构及字段和说明

oracle用sql查询描述表结构及字段和说明 Oracle SELECT DISTINCT AAA.COLUMN_NAME,AAA.DATA_TYPE,AAA.DATA_LENGTH,AAA.NULLABLE,BBB.COMMENTS FROM ALL_TAB_COLUMNS AAA,USER_COL_COMMENTS BBB WHERE AAA.COLUMN_NAME=BBB.COLUMN_NAMEAND AAA.TABLE_NAME='SY_

oracle用sql查询描述表结构及字段和说明

Oracle

SELECT DISTINCT AAA.COLUMN_NAME,AAA.DATA_TYPE,AAA.DATA_LENGTH,AAA.NULLABLE,BBB.COMMENTS 
	FROM ALL_TAB_COLUMNS AAA,USER_COL_COMMENTS BBB 
	WHERE AAA.COLUMN_NAME=BBB.COLUMN_NAME
	AND AAA.TABLE_NAME='SY_USER_JOB';