There are probably many products you could buy/download that do this type
thing.
This is the kind of stuff that I like using TOAD for. Not 100% sure, but I
think this feature is in the freeware version too (not just the commercial
version).
--
"Laly" <lalystar_at_free.fr> wrote in message
news:3fc2e7f1$0$28623$636a55ce_at_news.free.fr...
> Hello,
>
> You can have a look at SYS.DEPENDENCY$ i think it will help you, it
contains
> object_id.
>
> Laly.
>
>
> "Lakshmi Jagarlapudi" <jlnarayana_at_comcast.net> a écrit dans le message de
> news: zyBwb.220907$mZ5.1688466_at_attbi_s54...
> > 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 - 01:59:58 CST
