select table_name,column_name from user_tab_columns 
where column_name like '%column_name %';

更多推荐