PLSQL | MOD Function
MOD
a
b
Syntax:
MOD(a, b)
Parameters Used:
a
b
Return Value:
a
b
Supported Versions of Oracle/PLSQL is given below:
- Oracle 12c
- Oracle 11g
- Oracle 10g
- Oracle 9i
- Oracle 8i
Example-1:
DECLARE
Test_Number number1 := 15;
Test_Number number2 := 4;
BEGIN
dbms_output.put_line(MOD(Test_Number number1,
Test_Number number2));
END;
Output:
3
Example-2:
DECLARE
Test_Number number1 := 15;
Test_Number number2 := 0;
BEGIN
dbms_output.put_line(MOD(Test_Number number1,
Test_Number number2));
END;
Output:
15
Example-3:
DECLARE
Test_Number number1 := 11.6;
Test_Number number2 := 2.1;
BEGIN
dbms_output.put_line(MOD(Test_Number number1,
Test_Number number2));
END;
Output:
1.1
Advantage:
a
b
Contact Us