Lakshmi
- please don't shout ;-)
- the data dictionary views ALL_, USER_, and DBA_DEPENDENCIES contain the
information you need. In order to get a tree structure you could user
Oracle's CONNECT BY syntax (not standard SQL) but you may run into problems
using it on a view. another possibility is to write a recursively called
stored procedure or function to walk the tree
"Lakshmi Jagarlapudi" <jlnarayana_at_comcast.net> wrote in message
news:vxBwb.224805$9E1.1237375_at_attbi_s52...
| Hi Everybody,
|
| I have been working in Oracle database for a while. I am actually looking
| for an easy way to get a dependency tree. I know Oracle
| provides us with the script "utldtree.sql",however I am not really
succesful
| in using it.
|
| To be more clear, what I want is ,say if there is a package A, which
access
| package B, which access view V which in turn is based
| on table T. Then I want in a tree like structure the above dependencies
give
| the package A as a parameter.
|
| Please let me know if you have any soltution.
|
| thanks in advance.
|
|
Received on Tue Nov 25 2003 - 06:44:17 CST
