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 Oct 26 2001 - 13:44:31 CDT
