Re: how to display blank line in PL/SQL block?

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