Find column name of a particular string

So, basically when you need to find a particular column string from all the available table then its kind of lengthy process if you look into every table for particular column string so below query will make works more easier.

select table_name from dba_tab_columns where column_name='THE_COLUMN_YOU_LOOK_FOR';

Without DBA privileges:

select table_name from all_tab_columns where column_name='THE_COLUMN_YOU_LOOK_FOR';