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

原著是一个有趣的人,若有侵权,请通知删除