Tuesday, October 21, 2014

Find all objects in schema using column name

SELECT A.OWNER , TABLE_NAME, A.COLUMN_NAME
FROM DBA_TAB_COLUMNS A
WHERE COLUMN_NAME = 'ENAME';