接下来将会和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