Re: PL/SQL

Paul,
[Quoted] your function is a good example to begin with PL/SQL but i'm not agree with you when you say: "there is no easy way in SQL*PLUS to format a number with decimal places to print out as 000123.4500", the function TO_CHAR can do this:

[Quoted] v734> create table padnum (col number);
v734> insert into padnum values(1234.56);
v734> insert into padnum values(123.456);
v734> insert into padnum values(12345.678);
v734> insert into padnum values(123);
v734> select to_char(col, '000000.0000') from padnum;

TO_CHAR(COL,

 001234.5600
 000123.4560
 012345.6780
 000123.0000

--
Regards
Michel