Re: does oracle keep the same order the records were inserted?

Tansel Ozkan wrote:
>
> 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.

No.

Although most of the times you may see the records in same order. But this is not guarenteed. Well as such I can not think of any exception right away.

Pratap Received on Mon Nov 11 1996 - 00:00:00 CET