Oracle MetaData...

One of the most useful query to look for a Column in all tables:

SELECT
TABLE_NAME,
COLUMN_NAME
FROM
ALL_TAB_COLUMNS
where
COLUMN_NAME like '%COLUMN_NAME%';

More about it on : http://en.wikipedia.org/wiki/Oracle_metadata