Find table Name based on column name

[SNFBS]

how to get the table name based on column name?
I got column name but i dont know the location of that column, in which table.since i got about >300 tables in database

[r035198x]

Query for TABLE_NAME from ALL_TAB_COLUMNS

[Vemuri]

select table_name, column_name from all_tab_columns where column_name like 'X%'

Place your column Name in the place of 'X'