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 .