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?
Printable View
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?
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));
This would probably work, but
DBMS_OUTPUT.NEW_LINE;
is probably better.
Mike