-
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?
-
I figured it out
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|