The REMAINDER Function in Oracle SQL / PLSQL is used to get the remainder when m is divided by n.
Syntax for the using the REMAINDER Function in Oracle SQL / PLSQL is:
SELECT REMAINDER(m,n)
FROM table_name;
- The remainder is calculated using the formula:
- The REMAINDER function in Oracle SQL / PLSQL uses the round function, where as the MOD function in Oracle SQL / PLSQL uses the floor function in it’s calculation.
m-(n*A), here A is an integer nearest to m / n.
Examples:
Using REMAINDER Function in Oracle SQL / PLSQL SELECT statement:
1 | SELECT REMAINDER(10,3) |
2 | FROM dual; |
Will return ‘1’
1 | SELECT REMAINDER(11,3) |
2 | FROM dual; |
Will return ‘-1’
1 | SELECT REMAINDER(15,6) |
2 | FROM dual; |
Will return ‘3’
1 | SELECT REMAINDER(15.3,6.5) |
2 | FROM dual; |
Will return ‘2.3’