Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Identifing the source of a view column

Identifing the source of a view column

From: Peter <P.Slingerland_at_IMN.nl>
Date: Wed, 28 Feb 2001 14:52:31 +0100
Message-ID: <97ivp9$me4$1@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 - 07:52:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US