Home » SQL & PL/SQL » Client Tools » dbms_output.put_line
dbms_output.put_line [message #416709] Tue, 04 August 2009 01:07 Go to next message
suhasbr
Messages: 23
Registered: April 2008
Location: Chennai
Junior Member

Hi Gurus,

I have a SQL file in which i display an empty line before the Actaul data line. which would be soem thing like

DBMS_OUTPUT.PUT_LINE(' ');
DBMS_OUTPUT.PUT_LINE('--- Contact IS.');
DBMS_OUTPUT.PUT_LINE(' ');

This code is not working. Can any one help me out....


Thanks in advance
Re: dbms_output.put_line [message #416712 is a reply to message #416709] Tue, 04 August 2009 01:13 Go to previous messageGo to next message
vamsi kasina
Messages: 2089
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
What do you mean by not working?
We can't read your mind.

By
Vamsi
Re: dbms_output.put_line [message #416715 is a reply to message #416712] Tue, 04 August 2009 01:24 Go to previous messageGo to next message
suhasbr
Messages: 23
Registered: April 2008
Location: Chennai
Junior Member

I am unable to get the output in this desired fashion

<Empty line>
Conatct IS
<Empty line>

I am thinking to assign a variable NULL value and print it. But is there any other way other than this?




Re: dbms_output.put_line [message #416718 is a reply to message #416709] Tue, 04 August 2009 01:40 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
set serveroutput on format wrapped

regards,
Delna
Re: dbms_output.put_line [message #416720 is a reply to message #416715] Tue, 04 August 2009 01:42 Go to previous messageGo to next message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
set serveroutput on size 1000000 format wrap

Regards
Michel
Re: dbms_output.put_line [message #416722 is a reply to message #416709] Tue, 04 August 2009 01:53 Go to previous message
ayush_anand
Messages: 417
Registered: November 2008
Senior Member
  dbms_output.put_line(chr(13));

USE this
In Unix, a newline is a single line feed, chr(10)

In Windows, a newline is a carriage return, chr(13) followed by a line feed chr(10)

[Updated on: Tue, 04 August 2009 02:08]

Report message to a moderator

Previous Topic: set command
Next Topic: ERROR - ORA-12560: TNS:protocol adapter error
Goto Forum:
  


Current Time: Mon Apr 21 01:45:58 CDT 2014

Total time taken to generate the page: 0.05704 seconds