Hi Gurus,
I am working on a store procedure & I have a numeric field (MY_TABLE.NUM_FIELD) which is NUMERIC (18,2) & has results like below

NUM_FIELD
-----------
186.2
34.89
76.4
25
My store procedure requirement is to provide max 9 numbers including decimal (".") & 2 numbers after decimal point. Also my requirement is to add values up to 2 decimal points if the num is a whole num by keeping num_field right justified.
So far I have tried RPAD (TO_CHAR (NUM_FIELD, '99999.00'), 9). This logic gives me required decimal fields but then it makes output fields left justified (probably because to_char makes a num field a string). The perfectly desired results should be like below

NUM_FIELD
-----------
186.20
34.89
76.40
25.00

Thank you so much in advance for help & support.

SQL>   with data as
  2    (select 1.2 x from dual union all
  3     select 5     from dual union all
  4     select 22.7    from dual union all
  5     select 3.45  from dual )
  6  select
  7    x, to_char(x,'99999.99') x1
  8    from data;

         X X1
---------- ---------
       1.2      1.20
         5      5.00
      22.7     22.70
      3.45      3.45