Blank Line in Program?

[lesstjm]

I have a PL/SQL program using dbms_out.put_line to write to the screen. How to a put a carriage return in there so that it skips a line between outputs?

[lesstjm]

In the dbms_output.put_line you have to concatenate chr(10) to the end of the line. This is the carriage returns character number. So when oracle reads it, it enters a carriage return.

Ex:
dbms_output.put_line('Hello'||chr(10));

[m1l]

This would probably work, but

DBMS_OUTPUT.NEW_LINE;

is probably better.

Mike