SQL query for finding tables containing a column in my schema

Question

Can anybody tell me SQL query to return all the tables in my schema which have the column name "IS_REVIEW_APPEALS" ?

I am using Oracle database.

Thanks a lot,

Bhushan

Answer 1

SELECT table_name
  FROM user_tab_cols
 WHERE column_name = 'IS_REVIEW_APPEALS'