2 Replies Latest reply: Nov 30, 2012 6:36 AM by nazzu RSS

    Need Help on currency number format

    nazzu
      Hi,

      I need to display the amount as with Ruppes and Piase as follows.
      If my amount is 1000.00 then i need to display as '1000.00' and if 3456798.54 then i need to display as 3456798.54
      i have the sql query as
      select to_char('234567.00','FM999G999D99') from dual;
      but it is not displaying me the values after '.'
      Please help me how to fix this .


      Thanks,
      Nazzu