PL-SQL Blank-Lines

Wachs Rene wrote:
> To solve many problems, I have to use PL/SQL. For example, I have to generate
> an output like this :
>
> Line 1
> Line 2
>
> Line 3
>
> Line 4
>
> It's a MUST to insert blank-Lines between certain Records. To display these
> records I use the dbms_output-Package. It works fine, but the command
>
> dbms_output.put_line(' ') ;
>
> for insert a blank-Line is ignored by PL/SQL.
>
> Question : how to insert a blank-line in PL/SQL (with the dbms_output-Pck.) ?

Try :

SQL> begin

  2        dbms_output.put_line('Line 1'); 
  3        dbms_output.put_line('Line 2');
  4        dbms_output.put_line(chr(9));
  5        dbms_output.put_line('Line 3');

Line 1
Line 2  

Line 3  

This puts a TAB on the blank lines.
( You can just type the TAB inside quotes ) [ chr(10) gives two blank lines, chr(32) gives nothing. ]

Kevin.

 | / _     o  _    | _ | _   _  _  _   _    EMAIL  :  johnson_at_mail.esrin.esa.it
 || /_|\  /||/ |   |/ \|/ ||/ ||_ / \|/ |   PHONE  :  (+39) 6 941 80 633
 | \\__ \/ ||  | \_/\_/|  ||  |__|\_/|  |  ADDRESS :  European Space Agency
                                                      Via Galileo Galilei
        Information Administrator                     Frascati  00044   ITALIA.