Search for column names in an Oracle DB

SELECT OWNER,TABLE_NAME,COLUMN_NAME FROM ALL_TAB_COLUMNS 
WHERE COLUMN_NAME LIKE '%X%'


where "X" is the column name you are looking for