From: Pratap Singh <prsingh@cisco.com>
Subject: Re: does oracle keep the same order the records were inserted?
Date: 1996/11/11
Message-ID: <3287BD41.47E0@cisco.com>#1/1
references: <32874161.7C1@openix.com>
content-type: text/plain; charset=us-ascii
organization: Cisco Systems
mime-version: 1.0
reply-to: prsingh@cisco.com
newsgroups: comp.databases.oracle
x-mailer: Mozilla 3.0 (Win95; I)



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