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