Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to print new line using DBMS_OUTPUT package

480377Mar 6 2007 — edited Mar 7 2007
Hi,
I am trying to print a new line using DBMS_OUTPUT package. but it do not print the new line.

set serveroutput on size 200000
set feedback on

BEGIN
DBMS_OUTPUT.PUT_LINE('First Line');
DBMS_OUTPUT.PUT_LINE('');
DBMS_OUTPUT.PUT_LINE('Second Line');
END;

I expect following output ...
First Line

Second Line

but i got following output....
First Line
Second Line

why DBMS_OUTPUT.PUT_LINE( '); is not printing a new line ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 4 2007
Added on Mar 6 2007
9 comments
35,621 views