Re: Identifing the source of a view column

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 28 Feb 2001 14:37:19 -0000
Message-ID: <97j2f8$alk$1@soap.pipex.net>

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 - 08:37:19 CST