Re: Identifing the source of a view column

Only 2000! Boy, you can't have very complex views. By the way, I usually also set pagesize to 0 (zero) so as to get the whole view definition in one shot. Then I can scroll my xterm window to browse the definition.

Of-course, Niall is assuming that you are doing this via SQL*Plus. If not, then please disregard.

Niall Litchfield wrote:

> select text from user_views
> where view_name = '<your view name>';
>
> as the text of a view is stored in a LONG you may need to do set long 2000
> in sqlplus to get the entire text.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "Peter" <P.Slingerland_at_IMN.nl> wrote in message
> news:97ivp9$me4$1_at_nereid.worldonline.nl...
> > Hello,
> >
> > Does anyone know a script to select the source column for a view column.
> >
> > For example:
> >
> > create view v1 (f1, f2)
> > as select t1.f2, t2.f2
> > from t1,t2
> > where t1.f1=t2.f1;
> >
> > When I want the know the source for v1.f1 the script or function should
> > return
> > t1.f2.
> >
> > Thanks,
> >
> >
> > Peter
> >
> >
Received on Wed Feb 28 2001 - 23:06:19 CST