How to list all tables that contain a given column name?
January 19th, 2006 By kirtandesai
select c.table_name from all_tab_cols c where c.column_name = '&col_name'
The above query returns table names as well as view names.
Note: Answer edited by Admin.