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!

Need to display currency in Comma seperated value

588422Mar 6 2009 — edited Mar 7 2009

Hi,

I need to dispplay curreny amount lets say 198077 in 198,077 format. If the amount does not contain any decimal no decimal need to show up.

But if the amout has decimal then it has to show decimal. Ex 198,077.897

Also if the amount is 0 zero then it has to show only 0 not 0.0

Please advise

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 4 2009

Added on Mar 6 2009

15 comments

1,684 views