Oracle finding columns

 
 finding columns
 Find all tables that have at least one column that matches a specific PATTERN in the column name

 SELECT       TABLE_NAME,       COLUMN_NAME    FROM       ALL_TAB_COLUMNS    WHERE       COLUMN_NAME LIKE '%PATTERN%';