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

From: Hui, Kwok Miu <huikomix_at_dt.com.hk>
Date: 1996/11/14
Message-ID: <328BD671.2434_at_dt.com.hk>#1/1

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?

You cannot guanteed that.
It is better you open the cursor with an 'ORDER BY' clause.

-- 
Hui, Kwok Miu: Oracle DBA & Unix Administrator
               Cho Yang (Hong Kong) Co., Ltd.
email: huikomix_at_dt.com.hk
Tel  :(00852)2589 3369

Received on Thu Nov 14 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Simon: "Re: DB defragmentation"
Previous message: Jonathan Lewis: "Re: does oracle keep the same order the records were inserted?"
In reply to: Tansel Ozkan: "does oracle keep the same order the records were inserted?"
Next in thread: Simon: "Re: DB defragmentation"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message