RE: how do print blank lines using dbms_output.put_line package

RE: how do print blank lines using dbms_output.put_line package

 

  

I think you can use
dbms_output.put_line('Nitin' || chr(13) || chr(10) || chr(13) || chr(10) || 'Cholkar' || chr(13) || chr(10) || chr(13) || chr(10));

the two ascii characters chr(13) - carrage return, chr(10) - line feed. will allow to jump to a new line within the same dbms_output command.

Jagath

-----Original Message-----
From: Cholkar, Nitin B [mailto:nitin.b.[Email Address Removed]
Sent: Thu 11/27/2003 5:56 AM
To: LazyDBA.com Discussion
Cc:
Subject: how do print blank lines using dbms_output.put_line package



Can anyone tell me as how to print blank lines using
dbms_output.put_line package?

I want something like this

Nitin
<blankline>
Cholkar
<blankline>


Regards,
Nitin





--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed]
To subscribe: send a blank email to oracledba-[Email Address Removed]
By using this list you agree to these terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page