no. If it works it is just causing the machine to do more work for no
benefit.
Jim
"Bliss" <bliss_is_ignorance_at_hotmail.com> wrote in message
news:3bdee76c$1_1_at_news.tm.net.my...
> 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 - 19:03:35 CST
