SQL Select

From: <rjkdev_at_rocketmail.com>
Date: Thu, 04 Feb 1999 22:07:12 GMT
Message-ID: <79d5m7$bpb$1@nnrp1.dejanews.com>

I am writting a somewhat generic routine. All of my tables have an record ID, and an accounting date.

You pass the routine the Record ID and the Accounting date amd it updates it. Problem is, that the Record ID field in each table is called something different. (but its always first in the table)

Is it possible to reference the field by position instead of its name?

I know in MS Sql you do something like:

SELECT * from <table> as A where A.1 = 2345

Is the same thing possible with oracle?

Thanks in advance!

Robbie K -

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 04 1999 - 16:07:12 CST