Re: PL/SQL problem

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Sun, 22 Nov 1998 14:29:23 +0800
Message-ID: <3657AF43.76E6_at_bhp.com.au>


Lisa F. Miller wrote:
>
> Try
> dbms_output.put_line(' ');
>
> Alvin Huang wrote:
>
> > Hi,all
> >
> > I got a problem in PL/SQL
> > how can I put an empty line ....
> > I tried to use --- dbms_output.new_line,
> > but it's useless
> > is there any other functions that I can use to achieve the goal??
> >
> > Regards
> >
> > Alvin Huang,11/20

I don't think this will work, leading spaces are stripped off using dbms_output.put_line

SQL> set serveroutput on
SQL> exec dbms_output.put_line(' Leading spaces'); Leading spaces

PL/SQL procedure successfully completed.

SQL>

-- 
==============================================
Connor McDonald
[Quoted] BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad"
				- Salvador Dali
Received on Sun Nov 22 1998 - 07:29:23 CET

Original text of this message