Posts tagged: PLSQL

Sep 23 2009

How to insert Blank Line using PLSQL

SQL> set serveroutput on size 1000000
SQL> begin
  2   dbms_output.put_line(‘this is a line’);
  3   dbms_output.put_line(chr(9));
  4   dbms_output.put_line(‘another line’);
  5  end;
SQL> /
this is a line
       
another line

Alibi3col theme by Themocracy