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>
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 DaliReceived on Sun Nov 22 1998 - 07:29:23 CET