You should not rely upon this. The best way is to create a sequence, and
give each record a unique order by way of a sequence column. Then when you
select the records, you can order by the sequence number.
--
Richard Armstrong
State Of The Art Consulting, Inc.
http://www.stateoart.com
Cathy Cantieri <nojunk_at_nowhere.edu> wrote in message
news:01be9c9d$c55c1f60$f68f6d81_at_212833...
> When loading records into a table using SQL*Loader can you guaranty that
> the records will query out in the same order that they are in the datafile
> by truncating the table before the load? The table being loaded doesn't
> have any indexes or constraints on it. I have tested it several times and
> it has worked but before I put it in production I need to make sure that
it
> will continue to work. I have to be able to get the data records and
> process them in the exact order that they were in the datafile.
>
>
> --
>
> Cathy Cantieri
> mailto:cathy.cantieri_at_utmb.edu
Received on Wed May 12 1999 - 14:55:19 CDT
