MOD(x, y):Returns the remainder when x is divided by y : MOD « Numeric Math Functions « Oracle PL / SQL






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

MOD(x, y):Returns the remainder when x is divided by y

 


SQL>
SQL> --MOD(x, y):Returns the remainder when x is divided by y.
SQL>
SQL> select MOD(8, 3) from dual;

  MOD(8,3)
----------
         2

SQL>








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(8, 4)
4.MOD: If there is no remainder, the function returns a zero
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