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!

Calculate remainder of a division in Oracle

851268Apr 1 2016 — edited Apr 1 2016

Hello Folks

I am looking for a simple function which can calculate remainder of a division. For example if the function name is DIVIDE with parameters as (N1,N2) where N1 - Number to divide and N2 - Number with which N1 is to divide, then output of DIVIDE should be the remainder of the division. Simple mathematics division. No confusion of FLOOR or Ceiling. I have tried MOD and REMAINDER but not useful in my scenario.

Example, DIVIDE(663.81,3) should return me 0 and NOT 0.81 (which excel is returning me when I am using MOD function).

Any help would be really appreciate.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 29 2016

Added on Apr 1 2016

2 comments

772 views