Re: complex view-architecture

[Quoted] Hello Daniel,

I'm not sure if I understand Your answer. Do You think that all the required information is included in the view USER_VIEWS?
As far as I understand this the USER_VIEWS shows the view-code. But there is [Quoted] still a lot of work to do in order to get the column-dependencies.

e.g. there is a view
create or replace view test
as
select a.sp1 as test_sp1,

            b.sp1    as test_sp2,
            ....
from     tab1 a,
            tab2 b

the column-dependencies would be in this case: "
tab1.sp1 --> test.test_sp1
tab2.sp1 --> test.test_sp2
...
"

I do not understand how I get this information directly out of the user_views, sorry.
Can you or anyone else help me?

Bye,
Oli

"DA Morgan" <damorgan_at_exesolutions.com> schrieb im Newsbeitrag news:3E371AE6.D8F517F7_at_exesolutions.com...
> Oliver Stratmann wrote:
>
> > hello all,
> >
> > is there a tool which shows the column-dependencies of view-columns. if
yes,
> > over how many views does this tool work?
> > This functionality is needed for documentation, is there any other way
than
> > checking every single view-code?
> >
> > Thanks in advance!
> >
> > Bye,
> > Oli
>
> Do a describe on user_views.
>
> You will see that which you seek.
>
> Daniel Morgan
>
Received on Thu Jan 30 2003 - 20:25:40 CET