dbms_output.new_line;
"Thomas Kyte" <tkyte_at_oracle.com> wrote in message
news:ag9glq01fqq_at_drn.newsguy.com...
> In article <ag86cm$bvd$1_at_news6.jaring.my>, "CCC" says...
> >
> >How to display a blank line in PL/SQL block?
> >
> >i done something like this, but didn't work!
> >
> >BEGIN
> > DBMS_OUTPUT.PUT_LINE('Hello!');
> > DBMS_OUTPUT.PUT_LINE(' '); --this statement
> >didn't work!
> > DBMS_OUTPUT.PUT_LINE('Hello!');
> >END;
> >
> >
> >the output is as following:
> >
> >Hello!
> >Hello! <--- why no have a blank line??
> >
> >
> >can anybody explain y it's doesn't work???
> >i'm using oracle8i run on windows 2k...
> >
> >
> >
> >
>
> use this format of the serveroutput command:
>
>
> ops$tkyte_at_ORA817DEV.US.ORACLE.COM> set serveroutput on format wrapped
> ops$tkyte_at_ORA817DEV.US.ORACLE.COM> begin
> 2 DBMS_OUTPUT.PUT_LINE('Hello!');
> 3 DBMS_OUTPUT.PUT_LINE(' ');
> 4 DBMS_OUTPUT.PUT_LINE('Hello!');
> 5 DBMS_OUTPUT.PUT_LINE(' ');
> 6 end;
> 7 /
> Hello!
>
> Hello!
>
>
> PL/SQL procedure successfully completed.
>
> --
> Thomas Kyte (tkyte@oracle.com) http://asktom.oracle.com/
> Expert one on one Oracle, programming techniques and solutions for Oracle.
> http://www.amazon.com/exec/obidos/ASIN/1861004826/
> Opinions are mine and do not necessarily reflect those of Oracle Corp
>
Received on Sun Jul 07 2002 - 09:53:17 CDT
