Re: How to get info on view columns' source (field) ?

From: Peter van Rijn <pgm.van.rijnRM_at_THIShccnet.nl>
Date: Fri, 11 Oct 2002 14:14:41 +0200
Message-ID: <ao6f6j$fad$1@news.hccnet.nl>

Bjørge,

I'm very sorry, I read your question about five times and I still don't understand what it is you want. Please explain.

Peter

"Bjørge Sæther" <bjorge_at_itte.no> schreef in bericht news:1ccf751c.0210110404.4995841a_at_posting.google.com...
> Hi !
>
> (Ora 8.1.6)
>
> Given this table:
>
> CREATE TABLE PERSON (
> ID NUMBER(38) NOT NULL PRIMARY KEY,
> FIRST_NAME VARCHAR2(50),
> LAST_NAME VARCHAR2(50)
> )
>
> ...and this view:
>
> CREATE VIEW PERSON_LIST AS
> SELECT
> ID,
> FIRST_NAME||' '||LAST_NAME NAME
> FROM
> PERSON
>
> ...I want to get this information from Oracle about the view (format
> is not important, it is for internal use in a Delphi application):
>
> FIELD SOURCE
> -------------
> ID PERSON.ID
> NAME (CALCULATED)
>
> ...??
>
> Thanks in advance !
>
> Bjørge
Received on Fri Oct 11 2002 - 07:14:41 CDT