Oracle - How to search for a field name with a query

Posted by Blake on 3/6/2013
)

Basically, I wanted to quickly search a few hundred tables for any instances of a given column name. If you use “select *” you can get more fields like the data type, length, precision, etc. Anyway, here’s the SQL for posterity:

    select owner, table_name, column_name from all_tab_columns where column_name = 'ID'
    select owner, table_name, column_name from all_tab_columns where column_name in ('ID', 'FNAME')