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

> >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?
 

 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.

It's guaranteed to fail if you have the Parallel Query Option installed, and the Parallel slaves cut in on the query.

---
Jonathan Lewis
ora_mail_at_jlcomp.demon.co.uk