Re: insert statement using order by

It's not a bug. Why are you trying to insert the data ordered? There is no guarentee that the inserted data will stay in the same order all the time.

Lars Lerager wrote in message ...
>
>Stephen Pillow <stephen_pillow_at_i2.com> wrote in message
>news:_WqM3.3825$7K4.30709_at_typ11a.deja.bcandid.com...
>> Hi all,
>>
>> I would like to be able to take data from one table and put the data in
>> another table sorted. I have attempted to use the "insert into tablename
>> (select * from othertable order by desc)". However, Oracle 8 and 8i do
 not
>> support this(it is a bug).
>
>[CUT]
>
>I tried to do the same thing with my University database (Oracle 8.0.5
>running on HP-UX) Didn't work!
>Later i tried it at home with Oracle 8i EE (8.1.5 running on Windows NT) -
>Worked out fine!
>
>Go figure
>
>Lars
>
>
Received on Thu Nov 04 1999 - 00:00:00 CET