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

Pratap Singh <prsingh_at_cisco.com> wrote:

>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
Without getting into too much of the technical insides of Oracle - If there is room on a datablock Oracle will place a row/s on that page, this would be the case when the table has been in use for some time and there has been a number of deletes from that table.. If you are looking for data to be returned in specific order use an ORDER BY clause in your SELECT statement.
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Gordon E. Hooker MACS PCP
25 Clarke Street Ripley Queensland Australia Phone 61-7-32940555
Email gordonh_at_thehub.com.au
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ We are just two lost souls living in a fish bowl Year after year

Pink Floyd Received on Tue Nov 12 1996 - 00:00:00 CET