Home » SQL & PL/SQL » SQL & PL/SQL » dbms_output.put_line
dbms_output.put_line [message #1186] Tue, 09 April 2002 13:36 Go to next message
Julie Zolnowski
Messages: 9
Registered: April 2002
Junior Member
I am using dbms_output.put_line to display text. I would like to insert a blank line between my two rows of displayed text, what's the correct way to insert a blank line? Thanks.
Re: dbms_output.put_line [message #1191 is a reply to message #1186] Wed, 10 April 2002 06:35 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
declare
cursor c1 is select * from emp;
begin
for mag in c1 loop
exit when c1%notfound;
dbms_output.put_line(mag.ename);
dbms_output.put_line(' ');
end loop;
end;
Previous Topic: Re: VERY URGENT: HOW CAN I ROUND A NUMERIC VALUE UP TO THE HUNDREDS.
Next Topic: Can do it in SQL PLUS but not in PL/SQL
Goto Forum:
  


Current Time: Fri Apr 26 16:05:08 CDT 2024