Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_output.put_line question

Re: dbms_output.put_line question

From: Wayne Linton <lintonw_at_cadvision.com>
Date: 1997/08/26
Message-ID: <3403935B.2085@cadvision.com>#1/1

that is how dbms_output works. one of PL/SQL's little quirks!

Wayne Linton
Shell Canada Ltd.

Alan Long wrote:
>
> The line:
>
> dbms_output.put_line(' text string');
>
> produces output which omits the leading blanks. The only solution I have
> found is to include a leading period:
>
> dbms_output.put_line('. text string');
>
> This seems a bit dumb, uses up one column of output, and looks untidy. Is there
> a better way?
>
> I'm using Oracle 7.1.4 and PL/SQL 2.1.4
>
> --
> Alan Long
> Materials Systems Group
> Motorola, East Kilbride, Scotland
> email tics28@"spam-off"email.mot.com (remove the "spam-off")
  Received on Tue Aug 26 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US