Re: [PL/SQL] Overriding leading space removal in reports

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 Tue Mar 11 2003 - 14:40:41 CST