PLSQL | REMAINDER Function
Last Updated :
18 Oct, 2019
The REMAINDER function is an inbuilt function in PLSQL which is used to return the remainder of a divided by b.
Syntax:
REMAINDER(a, b)
Parameters Used:
This function accepts two parameters a and b which is used in calculating the remainder when a is divided by b.
Return Value:
This function returns a numeric value when the input number a is divided by b.
Supported Versions of Oracle/PLSQL is given below:
- Oracle 12c
- Oracle 11g
- Oracle 10g
- Oracle 9i
- Oracle 8i
Let’s see some examples which illustrate the REMAINDER function:
Example-1:
DECLARE
Test_Number number1 := 15;
Test_Number number2 := 5;
BEGIN
dbms_output.put_line(REMAINDER(Test_Number number1,
Test_Number number2));
END;
Output:
0
In the above example, when 15 is divided by 5 then it returns a remainder of 0.
Example-2:
DECLARE
Test_Number number1 := 11.6;
Test_Number number2 := 2;
BEGIN
dbms_output.put_line(REMAINDER(Test_Number number1,
Test_Number number2));
END;
Output:
-0.4
In the above example, when 11.6 is divided by 2 then it returns a remainder of -0.4
Example-3:
DECLARE
Test_Number number1 := -15;
Test_Number number2 := 4;
BEGIN
dbms_output.put_line(REMAINDER(Test_Number number1,
Test_Number number2));
END;
Output:
1
In the above example, when -15 is divided by 4 then it returns a remainder of 1.
Advantage:
This function is used to find out the remainder when a is divided by b.
Share your thoughts in the comments
Please Login to comment...