Find Table by providing the Field or Column Name

You can use below statement to look into those objects to which you have access

select * from user_tab_columns where column_name=''

else to check in those objects to which you dont have access as well, you can use the below queries

select * from all_tab_columns
select * from dba_tab_columns