Skip to Main Content
Forums

SQL & PL/SQL

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!

Finding dependency types inside a Procedure

Boobal GanesanJun 13 2017 — edited Jun 27 2017

Hello Folks,

I was given a requirement to find the tables list which is present inside a table along with their operation type (INSERT, UPDATE, DELETE, or SELECT). I am aware of USER_DEPENDENCIES view which gives us the dependencies between the objects but is there any other view which satisfies my request? I am aware that USER_DEPENDENCIES view does not bring up table names that are dynamic. Can someone help?

Thanks,

XOXO
This post has been answered by Boobal Ganesan on Jun 14 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 25 2017
Added on Jun 13 2017
18 comments
751 views