Re: dbms_output.put_line question

TICS28@"spam-off"email.mot.com (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?

Why not try:

          dbms_output.put_line(lpad('text string', n, ' '));

where n is the number of spaces you want?

-Darren

Darren Mallette
www.geocities.com/HotSprings/7490 Received on Mon Aug 18 1997 - 00:00:00 CDT