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!

Rounding Issue

Sandy4312May 10 2018 — edited May 10 2018

Hello -

SELECT TO_CHAR(NVL(MAX(98.56895),0),'990.99') as TEST_VALUE FROM DUAL

OUTPUT:

pastedImage_3.png

Expected Output:

Everytime when I SQL Runs I want only output first 2 values after decimal:

98.56

This post has been answered by jaramill on May 10 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 7 2018
Added on May 10 2018
18 comments
1,631 views