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!

number format

346165Apr 4 2008 — edited Apr 4 2008
Hi,

I have a $ amount like this: $100.50, but the users want it to be round up to $101 without any decimal. I can use round function to round up the number but how can I put the $ in front of it.

Thanks,

Helen
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 2 2008
Added on Apr 4 2008
6 comments
466 views