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

From: Bjørge Sæther <bjorge_at_itte.no>
Date: 11 Oct 2002 05:04:04 -0700
Message-ID: <1ccf751c.0210110404.4995841a@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:04:04 CDT