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';

1 comment:

  1. Thanks and Regards. Oracle Apps R12 & Fusion Training Videos at affordable cost. please check oracleappstechnical.com for details.

    ReplyDelete