Query For a table using column name

[davide++]

Hi all (and happy new year)

It's quite simple; run the query

SELECT TABLE_NAME
  FROM USER_TAB_COLUMNS
 WHERE COLUMN_NAME = 'MY_COLUMN'

It extracts all tables of the schema which have the column 'MY_COLUMN'
If you use DBA_TAB_COLUMNS instead of USER_TAB_COLUMNS, you'll find all table in any schema of the instance which have a specified column.