oracle 查询 所有表名及表名对应字段 字段类型可进行指定

SELECT table_name,column_name,data_type FROM user_tab_columns
where data_type in ('VARCHAR2','CHAR','NCHAR','NCLOB','NVARCHAR2')
and table_name not like 'RPT_STAT_%'
and table_name not like 'TMP_%'
and table_name not like 'DV%'
and table_name <> 'gh'
and table_name <> 'gjxwbjb'
and table_name <> 'gxfs'
and table_name <> 'rsj'
and table_name in (select table_name from user_tables)
order by table_name