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%';
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%';