select TABLE_NAME, COLUMN_NAME
from ALL_TAB_COLUMNS
where COLUMN_NAME LIKE '%컬럼명%';