My comments exactly....
"Alan" <alanshein_at_erols.com> wrote in message
news:9rv1i0$105n0o$1_at_ID-114862.news.dfncis.de...
> ROWID does not guarantee the order of entry, either. ROWID is an index to
> the datafile and block in which the row is stored. The blocks can be
> anywhere in the data file...
>
> "Bliss" <bliss_is_ignorance_at_hotmail.com> wrote in message
> news:3be2df79_2_at_news.tm.net.my...
> > 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 Sun Nov 04 2001 - 04:22:01 CST
