Forum Stats

  • 3,826,566 Users
  • 2,260,666 Discussions
  • 7,896,999 Comments

Discussions

View DBA_DEPENDENCY_COLUMNS

ApexBine
ApexBine Member Posts: 153 Silver Badge
edited May 7, 2020 7:29PM in Database Ideas - Ideas

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.

BPeaslandDBAabhinivesh.jainuser6195934ApexBineberx1932150Chris HuntRob van WijkMKJ10930279Sven W.N.B.sensoft2655500Gbenga Ajakayeuser12048529Marcel HoefsRainer Stenzeluser6459678Martin PreissMettemusens23509304Andreas Huberuser7904656MatthiasRogelOren Nakdimonconnor_mc_d-OracleAlex NuijtenErik van Roonuser3202444user13135250milan_sruser10887037jormart-OracleNiels HeckerPatrick Wolf-OracleTimur AkhmadeevMaarten van Luijtelaaruser11330282User_ZJDRZchristof_bTEAM DB-Support
41 votes

Under Review - Voting Still Open · Last Updated

Comments