oracle写求余函数,Oracle取余函数mod

接下来将会和oracle存储过程打交道，一切都是新的，从基础的学起吧

今天看几个函数：

1 mod 取余函数

SQL> declare

2 tmp number;

3 begin

4 for tmp in 1..10 loop

5 if mod(tmp, 2) = 0 then

6 dbms_output.put_line(tmp||' can be mod by 2.');

7 else

8 dbms_output.put_line(tmp||' can not be mod by 2.');

9 end if;

10 end loop;

11 exception

12 when others then

13 dbms_output.put_line('exception with :' || tmp);

14 end;

15 /结果:

1 can not be mod by 2.

2can be mod by 2.

3 can not be mod by 2.

4can be mod by 2.

5 can not be mod by 2.

6can be mod by 2.

7 can not be mod by 2.

8can be mod by 2.

9 can not be mod by 2.

10can be mod by 2.

PL/SQL procedure successfully completed