Re: does oracle keep the same order the records were inserted?
From: Jim Smith <jim_at_jimsmith.demon.co.uk>
Date: 1996/11/12
Message-ID: <ICub+WAJjHiyEwwG_at_jimsmith.demon.co.uk>#1/1
Date: 1996/11/12
Message-ID: <ICub+WAJjHiyEwwG_at_jimsmith.demon.co.uk>#1/1
In article <32874161.7C1_at_openix.com>, Tansel Ozkan <tansel_at_openix.com>
writes
>If I load the data into a table in a sorted order, and then open a
>cursor, is it guarenteed that the cursor will point to the records in
>the same order?
>Thanks...
>T.O.
Absolutly Not.
The only way to guarantee it is to use an order by clause.
Having said that it will probably work, as long s nothing is added to or taken away from the table.
-- Jim SmithReceived on Tue Nov 12 1996 - 00:00:00 CET