Re: Question about origin fieldname and tablename

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 26 Jan 2004 10:18:17 -0800
Message-ID: <1075141034.121108@yasure>

Jürgen Bauer wrote:

> Hello, Daniel,
>
> thanks for your reply.
>
>

>>All of this information is available in the data dictionary views:
>>
>>SELECT column_name
>>FROM all_tab_columns
>>WHERE owner = ...
>>AND table_name = ...
>>
>>But why are you writing such code in the first place? Why are you
>>aliasing column names? Why are you using 'AS' at all?

>
>
> We have written a general application server which is supposed to
> "understand" any SQL statement and to update the data. So it is not
> predictable which statement is sent to fetch the data.
> On the application server side we want to know which rows in which table we
> have to update. So it is very important for us to be able to extract this
> information.
> We already saw that the original ADO driver is capable to do this. Now we
> are looking for a way to obtain this via OCI.
>
>

>>Either way if you can write this:
>>
>> > SELECT a.NAME as SORTNAME, c.*
>> > FROM ADRESSES AS a, CONTACTS AS c
>> > WHERE a.ID = c.MASTERID
>>
>>Then you already know that SORTNAME's base column is NAME. Which, by the
>>way, is a reserved word in Oracle and should never be used as a column
>>name. Same goes for ID ... it is a reserved word.

>
>
> The statement is only supposed to be an example - not a real world statement
> :-).
>
> Bye,
> Jürgen Bauer
> BauerSoftware, Germany

Then my suggestion would be to not alias your columns and take a serious look at native dynamic SQL.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Mon Jan 26 2004 - 12:18:17 CST