Path: news.easynews.com!easynews!crtntx1-snh1.gtei.net!nycmny1-snh1.gtei.net!news.gtei.net!newsfeed.mathworks.com!pln-e!spln!dex!extra.newsguy.com!newsp.newsguy.com!drn From: Thomas Kyte Newsgroups: comp.databases.oracle.misc Subject: Re: how to display blank line in PL/SQL block? Date: 7 Jul 2002 06:45:30 -0700 Organization: Oracle Lines: 51 Message-ID: References: NNTP-Posting-Host: p-823.newsdawg.com X-Newsreader: Direct Read News 2.96 Xref: easynews comp.databases.oracle.misc:83902 X-Received-Date: Sun, 07 Jul 2002 07:04:03 MST (news.easynews.com) In article , "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@ORA817DEV.US.ORACLE.COM> set serveroutput on format wrapped ops$tkyte@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