查询Oracle数据库里所有表的字段信息

查询Oracle数据库里所有的表

select * from all_tab_comments where   owner ='数据库名称' 

查询某个表的字段信息

SELECT  atc.TABLE_NAME,	atc.COLUMN_NAME,	atc.DATA_TYPE,	atc.DATA_LENGTH, atc.NULLABLE,	acc.COMMENTS FROM	ALL_TAB_COLUMNS atc	LEFT JOIN ALL_COL_COMMENTS acc ON (atc.TABLE_NAME = acc.TABLE_NAME AND atc.OWNER = acc.OWNER AND atc.COLUMN_NAME = acc.COLUMN_NAME)  WHERE	1 = 1	AND atc.  TABLE_NAME = '表名称' 	AND atc.OWNER = '数据库名称'