MOD: If there is no remainder, the function returns a zero : MOD « Numeric Math Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Numeric Math Functions
  3. MOD

MOD: If there is no remainder, the function returns a zero

 

SQL>
SQL> --MOD: If there is no remainder, the function returns a zero.
SQL>
SQL> SELECT MOD(2200, 300) AS ODD, MOD(2100, 300) AS EVEN FROM Dual;

       ODD       EVEN
---------- ----------
       100          0








Related examples in the same category

1.MOD() returns the remainder of divided by
2.MOD: Returns the remainder of n/m where both n and m are integers
3.MOD(x, y):Returns the remainder when x is divided by y
4.MOD(8, 4)
5.In Oracle, when the second value is a 0, the MOD function returns the first value
6.select mod( 150.12, 2.6 )
7.Use mod() function to get all event employee id