Obtaining a list of tables for a specific column in Oracle DB.

DBA_TAB_COLUMNS is a view that will help us obtain a list of tables for a specific column in Oracle database.

example:
SELECT owner, table_name, column_name
FROM DBA_TAB_COLUMNS
WHERE column_name like '%ADDJ'
ORDER BY owner, table_name