View DBA_DEPENDENCY_COLUMNS

ApexBine

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.

1932150

This would be really helpful.

MKJ10930279

This addition will be of great help

Gbenga Ajakaye

This would come in handy. It would eliminate extra steps of getting details in sql.