Re: Order by Problem on 8i

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 Thu Oct 25 2001 - 11:19:59 CDT