How to Format Numbers??
596585Mar 13 2009 — edited Mar 13 2009
Hi,
I want to format the number. I tried witht the following format but it truncates the 0 before the decimal point.
select to_char(0.00,'999,999,999,999.99') from dual;
* , select to_char(0.13,'999,999,999,999.99') from dual;*
If I have a number like 120000.13 then it gives fine result.
select to_char(120000.13,'999,999,999,999.99') from dual;
Else it truncates the 0 before the decimal point.
Please anybody help me to solve this.
Thanks
Alaka