oracle存储过程入门1

1. 块结构：

declare

    width INTEGER;

    height INTEGER := 2;

    area INTEGER;

BEGIN

    area := 6;

    width := area/height;

    DBMS_OUTPUT.PUT_LINE('width = '|| width);

    insert into PCRF_RULEITEM(RULEID,RULEITEMID,RULEITEMNAME,DISPLAYORDER,NOTE) values (132,132,'test',0,'ttt');

EXCEPTION

    WHEN ZERO_DIVIDE THEN

    DBMS_OUTPUT.PUT_LINE('Division by zero');

END;

/

1. 存储过程样例：

create or replace procedure testp

as

begin

    insert into PCRF_RULEITEMTEST(RULEID,RULEITEMID,RULEITEMNAME,DISPLAYORDER,NOTE) values (1132,1132,'11test',0,'ttt');

end;

/

exec testp

1. 在sqlplus终端中/表示结束上面的存储过程并编译
2. 也可以写在脚本文件中，然后在sqlplus中@/home/oracle/test.sql即可调用