hi,

I am printing a number using below to_char format :

declare
var number(6,2)
begin
var := 65.2
dbms_output.put_line(to_char(var,'9999.99'));
end;

the above code prints ' 65.20' (3 spaces and the number).
one extra space is printed because positive value contain one extra space in to_char. I can not use FM because it will remove all the spaces(4 spaces) and my requirement is to print a number with length equals to the maximum length of number. If the length is less than the maximum length of number then add spaces up to the maximum length of number and print two digit after decimal.
I want to print ' 65.20'(2 spaces and number) from above code.
Please suggest.
Thanks!!

SQL> declare
  2  var number(6,2);
  3  begin
  4  dbms_output.put_line('-------');
  5  var := 65.2;
  6  dbms_output.put_line(lpad(to_char(var,'FM9999.00'),7));
  7  var := 165.2;
  8  dbms_output.put_line(lpad(to_char(var,'FM9999.00'),7));
  9  var := 3165.2;
 10  dbms_output.put_line(lpad(to_char(var,'FM9999.00'),7));
 11  end;
 12  /
-------
  65.20
 165.20
3165.20

PL/SQL procedure successfully completed.