Search for column names in Oracle

SELECT * FROM USER_TAB_COLUMNS WHERE COLUMN_NAME='COLUMN_NAME' ;
SELECT * FROM ALL_TAB_COLUMNS WHERE COLUMN_NAME='COLUMN_NAME' ;

Try the following also:

• DBA_TAB_COLUMNS
  
• all_constraints (user_constraints, dba_constraints)
• all_indexes
• all_tables
• all_tab_columns