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

• Original Message ----- From: "Peter van Rijn" <pgm.van.rijnRM_at_THIShccnet.nl.agmasys.com> To: "Bjørge Sæther" <bjorge_at_itte.no> Sent: Friday, October 11, 2002 2:14 PM Subject: Re: How to get info on view columns' source (field) ?

| 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

Hi !

What I'm after, is knowing what kind of fields exists in a result set. The stmt "select * from person_list" returns columns that are partly identical to the field as found in the underlying table ("ID" in my example), partly calculated columns ("NAME" in my example). This info I need.

Thank you.

|
| "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
|
|
|

Bjørge Sæther Received on Fri Oct 11 2002 - 12:42:56 CDT