In Oracle, the remainder function is MoD (numer1, number2)

In Oracle, the remainder is obtained using the MOD (numer1, number2) function, and the returned value is the other values. For example:

Output 1 ~ All integer values in 13 that are not multiples of 3.

Declare -- I number; begin for I in 1 .. 13 loop if Mod (I, 3 )! = 0 then dbms_output.put_line ('integer not a multiple of 3: '| + I); end if; end loop; Exception when others then dbms_output.put_line (sqlcode | ': '| sqlerrm); end;

 

The output value is:

An integer that is not a multiple of 3: 1
An integer that is not a multiple of 3: 2
An integer that is not a multiple of 3: 4
An integer that is not a multiple of 3: 5
An integer that is not a multiple of 3: 7
An integer that is not a multiple of 3: 8
An integer that is not a multiple of 3: 10
An integer that is not a multiple of 3: 11
An integer that is not a multiple of 3: 13