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
Ethel Aardvark wrote:
> 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
Not "or"
Thanks for the correction. My fingers were moving faster than my synapses.
Daniel Morgan Received on Wed Mar 12 2003 - 10:41:45 CST