Find which table has a particular column in Oracle

Sometimes we need to find out which tables contain a particular column. In Oracle this can be simply done by querying the DBA_TAB_COLUMNS system table:

SELECT * FROM DBA_TAB_COLUMNS WHERE COLUMN_NAME = 'ACME';