表名

select * from all_tables;

表名及注释信息

select * from all_tab_comments where owner='ZFW_WW_DC'

字段注释，表名，模式名

select * from all_col_comments ;

表名&字段名&字段类型

SELECT 
	T.TABLE_NAME,
	TT.COMMENTS,
	CONCAT(T.TABLE_NAME,'(', TT.COMMENTS, ')'),
	T.COLUMN_NAME,
	T.COMMENTS,
	CONCAT(T1.DATA_TYPE,'(', T1.DATA_LENGTH ,')')
FROM
	(
	select 
		* 
	from 
		all_tab_comments 
	where owner = 'ZFW_WW_LOCAL'
	
	) TT 
LEFT JOIN
	(
	select 
		* 
	from 
		all_col_comments
	where 
		schema_name = 'ZFW_WW_LOCAL'
	) T 
ON T.TABLE_NAME = TT.TABLE_NAME
LEFT JOIN
	(
	select 
		TABLE_NAME,
		COLUMN_NAME,
		DATA_TYPE,
		DATA_LENGTH
	from all_tab_columns
	WHERE 
		OWNER = 'ZFW_WW_LOCAL'
	)T1
ON T.TABLE_NAME = T1.TABLE_NAME AND T.COLUMN_NAME = T1.COLUMN_NAME