Re: Order by Problem on 8i

David,

I think we had this discussion on mail before....

Regards,
Bliss
"David Fitzjarrell" <oratune_at_msn.com> wrote in message news:32d39fb1.0110261044.2d36ccf6_at_posting.google.com...
> In the absence of any other ordering Oracle DOES display data in the
> order it was inserted into the table. The default behaviour is to
> order by ROWID.
>
> "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 Fri Nov 02 2001 - 12:01:44 CST