Skip navigation

View DBA_DEPENDENCY_COLUMNS

score 300
You have not voted. Active

I think many people use the views [DBA|ALL|USER]_DEPENDENCIES, but like me they miss a more detailed view which also tells them which columns of a table or view are referenced.

This would be really helpful as parsing view definitions and source code is quite tedious.

 

What do you think of an easy way of accessing this information - like this, perhaps?

 

Info: Rob van Wijk did some great research on this: About Oracle: DBA_DEPENDENCY_COLUMNS
I used it to create the example.

Comments

Vote history