REMAINDER
Example
Section titled “Example”SELECT REMAINDER(10, 3) FROM dual;Output
Section titled “Output”1Explanation
Section titled “Explanation”The REMAINDER function in Oracle is used to return the remainder of a division operation between two numbers. In this case, 3 divides into 10 three times with one left over. So the output of the function REMAINDER(10, 3) is 1.
Example
Section titled “Example”SELECT REMAINDER(7, 3) AS Result;Output
Section titled “Output”Result-----------1Explanation
Section titled “Explanation”The REMAINDER function returns the remainder of the division of the first argument by the second one. In this case, it returned 1 because the remainder of the division of 7 by 3 is 1.