Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 10 2009
Added on Mar 13 2009
7 comments
1,407 views