From column how can i find which table has that column in Oracle

select * from all_tab_columns
where owner = 'SCOTT'
and table_name = 'EMP'
and column_name = 'ENAME';



ALL_TAB_COLUMNS describes the columns of the tables, views, and clusters accessible to the current user. To gather statistics for this view, use the ANALYZE SQL statement or the DBMS_STATS package


DBA_TAB_COLUMNS describes the columns of all tables, views, and clusters in the database.


USER_TAB_COLUMNS describes the columns of the tables, views, and clusters owned by the current user. This view does not display the OWNER column.