Skip to Main Content
Forums

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 set format mask for number value

539772Jul 22 2008 — edited Jul 22 2008
Hi all,

How to set format mask for number value. The following is an example:
For 0.618865551 the output should be 0.61. Irrespective of the number of digits after the decimal point I need to display only 2 decimal places.

I tried by using to_number function but it not work.

Your help would be more appreciated.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 19 2008
Added on Jul 22 2008
2 comments
463 views