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 number according to Bankers algorithm

385050Jan 9 2003 — edited Jan 9 2003

I need an oracle function which performs Bankers algorithm to round number value. ROUND() function in Oracle performs rounding of 0.5 to 1 and 1.5 to 2 which results in adding extra 0.5 value each time it is used. In the Bankers algorithm 0.5 will round to 0 and 1.5 will round to 2 which balances the effect when the two rounded values are added.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 6 2003

Added on Jan 9 2003

4 comments

2,198 views