DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Blank Line in Program?

  1. #1
    Join Date
    Jan 2001
    Posts
    515
    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?

  2. #2
    Join Date
    Jan 2001
    Posts
    515

    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));

  3. #3
    Join Date
    Oct 2000
    Posts
    90
    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
  •  


Click Here to Expand Forum to Full Width