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 -> Re: Difference between 8i and 9i

Re: Difference between 8i and 9i

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 29 Oct 2002 16:44:21 GMT
Message-ID: <3DBEBAE3.F7875A06@exesolutions.com>


"Bruno D." wrote:

> 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 ?????

It is neither ... it is a difference.

Daniel Morgan Received on Tue Oct 29 2002 - 10:44:21 CST

Original text of this message

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