In Oracle, when the second value is a 0, the MOD function returns the first value : MOD « Numeric Math Functions « Oracle PL / SQL






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

In Oracle, when the second value is a 0, the MOD function returns the first value

 

SQL>
SQL>
SQL> --MOD(1000, 0)
SQL>
SQL> --In Oracle, when the second value is a 0, the MOD function returns the first value
SQL> --(which deviates a bit from the rules of mathematics).
SQL>
SQL> SELECT MOD(1000, 0) AS ZERO_DIVIDE FROM Dual;

ZERO_DIVIDE
-----------
       1000

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(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.select mod( 150.12, 2.6 )
7.Use mod() function to get all event employee id