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

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 10 2009

Added on Mar 13 2009

7 comments

1,405 views