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 Referenced Objects recursively

user10566312Sep 25 2013 — edited Oct 1 2013

Hi,

I have some views. I would like to find out all the referenced table, functions, views inside those views. In case the views references another view then I would like to know the objects referenced inside the child view and so on. Can someone provide me the SQL for this? Would be nice if the output is nicely formatted.

Also, I want to drill down to further level only in case the referenced object is a view.

Message was edited by: user10566312

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 29 2013

Added on Sep 25 2013

14 comments

4,450 views