Re: dbms_output.put_line question

I like the response of:
  dbms_output.put_line(lpad('text string', n, ' ')); but prefer it modified as:
  dbms_output.put_line (lpad (text_var, length (text_var) + 10)); This way you can get the exact spacing you want for each string.

In article <33f85f19.174344125_at_207.93.1.8>,   khs_rider_at_geocities.com (Darren Mallette) wrote:
>
> 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

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet