QUERY TO FIND TABLE NAME BY COLUMN NAME

QUERY TO FIND TABLE NAME BY  COLUMN NAME

SELECT TABLE_NAME FROM USER_TAB_COLUMNS
WHERE COLUMN_NAME like'%COLUMN_NAME%' and TABLE_NAME LIKE 'TABLE_NAME%' 

OR

SELECT TABLE_NAME FROM USER_TAB_COLUMNS
              WHERE COLUMN_NAME ='COLUMN_NAME' and TABLE_NAME= 'TABLE_NAME'