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


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 Smith
Received on Tue Nov 12 1996 - 00:00:00 CET

Original text of this message