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

Tansel Ozkan (tansel_at_openix.com) 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.

it is not guaranteed.
the order you get the records back will depend on the order by clause in the cursor. If you do not have an order by clause, then you will get <basically> unpredictable order of rows returned.

Randy :)

--
    ..uu.           Randy DeWoolfson          ----------------------
  .?$" '?i     .                              I  randyd_at_cais.com   I
 .T^M  ._at_"    d9    .    .f   ,.un.  t     ,  I--------------------I
 "  Z :#"    M `8   U    <  .dP"``Y# `M   _at_"  I brandall_at_erols.com I
    &H?`    Xl _R   $5.  $  ?*    _at_   'P,#"   I--------------------I
  ,d#^*L   :RP'~$b  f`$L:M  Xf  .f'    dH`    I     ,\//.      X   I
    &  'M ,P    `E  M   "$  Mux~      n!`     I     |o o|          I
   dk   `h"       ' j     " y"       *~       I=oOO==(_)==Ooo======I