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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to convert averge value to two decimal point ?

1058340Dec 4 2013 — edited Dec 5 2013

hi Team

my peer facing one Business issue after calculating Avg value he is getting floating no. but he want to restrict to two decimals.

then he used cast function like this

CAST (avg(Value) as number(6,2)).

i suggested to use round function.

does anyone have better solution.

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 2 2014

Added on Dec 4 2013

7 comments

4,459 views