Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

View DBA_DEPENDENCY_COLUMNS

ApexBineMar 15 2016 — edited May 7 2020

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?

pastedImage_5.png

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

Comments

Post Details

Added on Mar 15 2016
3 comments
1,347 views