Re: DBMS_OUTPUT

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 02 Jul 1998 01:03:57 GMT
Message-ID: <359bdc62.812077_at_192.86.155.100>

A copy of this was sent to dw724_at_cleveland.Freenet.Edu (Dennis M. Hancy) (if that email address didn't require changing) On 1 Jul 1998 18:08:12 GMT, you wrote:

>
>How does one print a blank line using DBMS_OUTPUT?
>
>I tried this:
> DBMS_OUTPUT.PUT_LINE(' ');
>
>but it didn't work. Any ideas? Thanks.
>
>
>
>Dennis Hancy

It won't be entirely blank, but it will put out a whitespace line:

SQL> begin

  2  dbms_output.put_line( 'Hello' );
  3  dbms_output.put_line( chr(9) );
  4  dbms_output.put_line( 'world' );

  5 end;
  6 /
Hello         

world

chr(9) is a tab...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Jul 02 1998 - 03:03:57 CEST