Find all tables in db with column name of a particular string.

Simple Steps to Do!!

Without System Privileges :

select table_name from all_tab_columns where column_name='THE_COLUMN_YOU_LOOK_FOR';

With System Privileges:

select table_name from dba_tab_columns where column_name='THE_COLUMN_YOU_LOOK_FOR';