Re: insert statement using order by

From: Lars Lerager <lerager_at_get2net.dk>
Date: 1999/11/04
Message-ID: <cUkU3.1264$y4.44974_at_news010.image.dk>#1/1

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

This message: [ Message body ]
Next message: John Duran: "Drop Column"
Previous message: lofftjm_at_itec.suny.edu: "Oracle Application Server xlf.log file and Webtrends"
Maybe in reply to: Wise Guy: "Re: insert statement using order by"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message