Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: [PL/SQL] Overriding leading space removal in reports
Or LPAD!
DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E6E49C9.EF94122C_at_exesolutions.com>...
> Ubiquitous wrote:
>
> > I have a PL/SQL script which produces a columner report.
> > However, the first column is a NUMBER data type, so if I replace
> > the leading zeros with spaces the values get left-aligned.
> > Other than printing the value with leading zeros, is there a
> > way to make the values line up to the right?
>
> Look at the RPAD function. And pad with spaces
>
> Daniel Morgan
Received on Wed Mar 12 2003 - 05:52:15 CST