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

"Scott Mattes" <Scott_at_TheMattesFamily.ws> skrev i melding news:0_zp9.22047$m92.4975974_at_news1.news.adelphia.net...
> Delphi, now there is a RAD!

No RAD at all...dealing with it programmatically wasn't excactly what Delphi was built for...;-)

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

Yes, I know that I can get the source.....just didn't want to actually *write* an SQL parser...expecially when dealing with a variety of Oracle SQL statements...

I was afraid of that answer...but thank you !

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

--
Bjørge Sæther
bjorge_at_hahaha_itte.no