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!

How to get a quotient value in a division?

843414Apr 13 2011 — edited Apr 14 2011
The MOD function returns the remainder of a division, but how can we get the value in quotient?

I want to check if the quotient of a division has a decimal followed by 5 (xxxx.5) to apply banker's rounding.

Or is there a different function to calculate banker's rounding in Oracle?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 12 2011
Added on Apr 13 2011
8 comments
13,350 views