Re: [GENERAL] Re: [SQL] oracle rownum equivalent?

2000-06-08 Thread mikeo
At 06:47 PM 6/7/00 -0400, Cary O'Brien wrote: thanks for the response. oid is equivalent to oracle rowid. I think there is a fundamentel difference between oid and rownum. Oid is just a serial number. Rownum is a long string that tells oracle where exactly the row is. So *I think* rownum

Re: [GENERAL] Re: [SQL] oracle rownum equivalent?

2000-06-08 Thread Cary O'Brien
At 06:47 PM 6/7/00 -0400, Cary O'Brien wrote: thanks for the response. oid is equivalent to oracle rowid. I think there is a fundamentel difference between oid and rownum. Oid is just a serial number. Rownum is a long string that tells oracle where exactly the row is. So *I think*

Re: [GENERAL] Re: [SQL] oracle rownum equivalent?

2000-06-07 Thread Cary O'Brien
thanks for the response. oid is equivalent to oracle rowid. I think there is a fundamentel difference between oid and rownum. Oid is just a serial number. Rownum is a long string that tells oracle where exactly the row is. So *I think* rownum can be used for fast lookups, where oid,

RE: [GENERAL] Re: [SQL] oracle rownum equivalent?

2000-06-07 Thread Hiroshi Inoue
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ed Loehr mikeo wrote: thanks for the response. oid is equivalent to oracle rowid. IMHO,tid is equivalent to Oracle's rowid. rownum can be used similar to the limit option of select in postgres