APEX

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 make the value appears with 2 digits ?

Christian PitetJun 5 2019 — edited Jun 7 2019

Hi,

I have a form and I want a value to appear with two digits after the comma. It appears like that "27,6" but I would like it to appear like that "27,60". I have indicated a mask format for the item like this without effect : "999G999G999G999G990D00''. I have also tried to make a computation but it does't work either : "select to_char(prix_ttc, '9999999999D00') "Prix TTC" from GS_ARTICLE where PK = :P12_PK".

Thank you for your help.

This post has been answered by ebenwalker on Jun 6 2019

Jump to Answer

Added on Jun 5 2019

#apex-discussions

8 comments

282 views