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

From: Thomas Kyte <tkyte_at_oracle.com>
Date: 7 Jul 2002 10:18:14 -0700
Message-ID: <ag9t4m02ed0@drn.newsguy.com>

In article <xBYV8.22830$ix.3464_at_afrodite.telenet-ops.be>, "Van says...
>
>dbms_output.new_line;
>

you still need serveroutput on format wrapped

ops$tkyte_at_ORA817DEV.US.ORACLE.COM> set serveroutput on ops$tkyte_at_ORA817DEV.US.ORACLE.COM> begin

  2  dbms_output.put_line( 'hello' );
  3  dbms_output.new_line; 
  4  dbms_output.put_line( 'world' );

  5 end;
  6 /
hello
world

PL/SQL procedure successfully completed.

ops$tkyte_at_ORA817DEV.US.ORACLE.COM> set serveroutput on format wrapped ops$tkyte_at_ORA817DEV.US.ORACLE.COM> /
hello

world

PL/SQL procedure successfully completed.

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

--
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 - 12:18:14 CDT