Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Difference between 8i and 9i

Difference between 8i and 9i

From: Bruno D. <bd_avirer__at_arte-tv.com>
Date: Mon, 28 Oct 2002 17:54:21 +0100
Message-ID: <3dbd6bae$0$7111$4d4eb98e@read.news.fr.uu.net>


Hi everybody,

I have noticed some differences between oracle 8i and 9i release 2.

Consider this PLSQL statement:

declare
cursor toto is
select 'AA' col from dual
union all
select 'BBBB' from dual;
begin
  for titi in toto loop
    DBMS_OUTPUT.PUT_LINE ( '-'||titi.col||'-' );    end loop;
end;

On 8i the result is: -AA<space><space>-

-BBBB-
On 9i the result is: -AA-

-BBBB-
Is this a bug or a feature ????? Received on Mon Oct 28 2002 - 10:54:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US