2 Replies Latest reply on Nov 30, 2012 12:36 PM by nazzu

    Need Help on currency number format


      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 .