MOD « Numeric Math Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Numeric Math Functions
  3. MOD
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.MOD: If there is no remainder, the function returns a zero
6.In Oracle, when the second value is a 0, the MOD function returns the first value
7.select mod( 150.12, 2.6 )
8.Use mod() function to get all event employee id