Re: Insert without a Primary Key

From: David Blanton <Dblanton_at_lads.com>
Date: 1997/08/26
Message-ID: <340316e2.593307461@client.se.news.psi.net>#1/1

On Tue, 26 Aug 1997 07:40:23 -0400, Stan Novinsky <stan_novinsky_at_jhuapl.edu> wrote:

>A question:
>
>150 rows of data are inserted into a table without a primary key.
>
>When a select is executed on the table, will the 150 rows of data be
>retrieved
>in the same order as inserted - (ie. row 1 inserted into the table
>table will always be row 1 retrieved.)
>
>Thanks
>
>

The rows will NOT necessarily be retrieved in the same order as they are inserted. I have pursued this issue in the past with Oracle Corp. and done independent tests, both of which confirm this is true.

dblanton_at_lads.com Received on Tue Aug 26 1997 - 00:00:00 CDT