Re: Order by Problem on 8i

A friend just brought to my notice that

CREATE TABLE .... AS SELECT .... ORDER BY does work... will that help in any way????

Regards,
Bliss

"Bliss" <bliss_is_ignorance_at_hotmail.com> wrote in message news:3bd83ba3_1_at_news.tm.net.my...
> Hi,
>
> Though your script works in 9i, it seems a little illogical to me.... How
> can you INSERT using ORDER BY? What will you achieve by doing this???
> Remember that Oracle does not display data in order it is inserted when
you
> give a SELECT statement. If you can specify what you are trying to
achieve,
> may be there'll be a solution...
>
> Regards,
> Bliss
>
> "tIM" <tjm_at_geac.dk> wrote in message
> news:b1f8412c.0110250426.69c05a26_at_posting.google.com...
> > Hi I am faced with a problem ...
> >
> > If I run the following code on Oracle 8i the create procedure fails. I
> > can't figure out why because the command alone works!!!
> >
> > Note that this works on 9i (is this a confirmed bug with a patch or
> > anything!!!?!?)
> >
> > TIA
> >
> > CREATE TABLE TEST1(
> > test1 number(1));
> >
> > CREATE TABLE TEST2(
> > test1 number(1));
> >
> >
> >
> > insert into test1 (test1) select test1
> > FROM
> > test2
> > WHERE
> > test1='ss'
> > ORDER BY test1;
> >
> > CREATE PROCEDURE TEST
> > IS
> > BEGIN
> > insert into test1 (test1) select test1
> > FROM
> > test2
> > WHERE
> > test1='ss'
> > ORDER BY test1;
> > END;
> > /
>
>
Received on Tue Oct 30 2001 - 11:46:36 CST