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!

rounding values for display

bjorn toulouseJul 24 2006 — edited Jul 28 2006

Hi all hope you can help.
I have a numeric DB column say 566785.8975. The value of the information in the column cant be changed. The application performs two functions data input for the owners and view for the customers.

Idealy I want to only display to two decimal points for the customers
I have tried using the the ROUND command with no success using source as a PL/SQL expression or function and a value of ROUND(GROSS,2) where GROSS is the column name

any ideas?
Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 25 2006

Added on Jul 24 2006

#apex-discussions

10 comments

933 views