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!

How to find the tables used in a procedure

Mark1970Jan 13 2012 — edited Jan 13 2012

Hi,
I need to write a SQL for finding the procedures (from user_source) and/or the triggers (from user_triggers) whose code contains the tables registerd in a table X.
In others words, I have a table X with N records having a column containing some tables. I want to write a SQL for getting those objects (proc, package and triggers) containing/using those tables inside
Can you help me?
Thanks!

This post has been answered by db-geek on Jan 13 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 10 2012

Added on Jan 13 2012

#plsql, #sql

9 comments

2,605 views