MOD() returns the remainder of divided by : MOD « Numeric Math Functions « Oracle PL / SQL






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

MOD() returns the remainder of divided by 

  
SQL>
Syntax: MOD(<numeric_expression1>,<numeric_expression2>)
SQL>
SQL>
SQL> SELECT
  2     MOD(10,5) remainder1,
  3     MOD(10,3) remainder2 from dual;

REMAINDER1 REMAINDER2
---------- ----------
         0          1








Related examples in the same category

1.MOD: Returns the remainder of n/m where both n and m are integers
2.MOD(x, y):Returns the remainder when x is divided by y
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