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

Delphi, now there is a RAD!

The view ALL_VIEWS contains the source used to create the view (its the only place that I know of for the information). 'Just' parse it out to find the table/s and field/s of the view, then look in ALL_TAB_COLUMNS for the information you want.

"Bjørge Sæther" <bjorge_at_itte.no> wrote in message 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 - 08:02:52 CDT