Skip navigation


score 320
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.


Vote history