If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

Find Column Dependencies

I am having to pull out all the dependencies for a column as below.
When I select a column in a table, it should list
1. All Views that use this column and table
2. All Stored procs that use this column and table
3. All Functions that use this column and table
4. All Pl/SQL scripts that use this column and table.

Is there a easy way of getting this information from the Oracle dba tables?

Is there a easy way of getting this information from the Oracle dba tables?

No. While DBA_TAB_COLUMNS shows what columns is in what view it is going to be difficult to see how do you know where the column came from? You can grep through the DDL for the view and stored procedures, but converting it into a view is going to be difficult. Especially since you can do dynamic SQL in stored procedures and you can alias, concatenate and rename columns.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.