If you don't have any column to order by then how would you know what the
right order is? By definition the data in a table is unordered and you
select a group or ret of records and unless you specify an order then you
can't guarantee the order it comes back. Why not have an extra column that
is the seeded with a sequence and order by that?
Why is the order not important? If you don't have a primary key how do you
distinguish one row from another?
Jim
"Puneet" <puneet.bansal_at_wipro.com> wrote in message
news:4c276d80.0311122127.562b3607_at_posting.google.com...
> Hi everybody !
> I am loading a CSV file into Oracle 8i table using SQL Loader
> utility. The data is in such a format that the order of the records is
> of paramount importance. But when I retrieve the data from the table
> it can be in any order, isn't it?
>
> My doubts are:
> Does SQL Loader always load the records in the same order as that of
> the data file?
>
> If yes then how can I ensure that when I retrive the records they are
> always in the same order as the one specified in CSV file? (The table
> is just a temp table and it doesn't have any primary key or any column
> I can order by.) Will 'order by rowid' solve the problem?
>
> Thanks for your time and help.
>
> Puneet
Received on Thu Nov 13 2003 - 00:00:15 CST
