软件:PL/SQL Developer
1、新建SQL窗口,输入如下:
CREATE OR REPLACE PROCEDURE skeleton IS BEGIN NULL; END;
保存为skeleton.sql;
2、新建命令窗口,输入并执行:
SQL> EXECUTE skeleton
PL/SQL procedure successfully completed
一个最简单的存储过程被创建成功;
3、修改存储过程,打开skeleton.sql,修改保存结果如下:
CREATE OR REPLACE PROCEDURE skeleton IS BEGIN DBMS_OUTPUT.PUT_LINE('Hello World!'); END;
4、命令窗口下执行如下操作,输出Hello World!
SQL> EXECUTE skeleton;
PL/SQL procedure successfully completed
SQL> SET SERVEROUTPUT ON
SQL> EXECUTE skeleton;
Hello World!
PL/SQL procedure successfully completed
5、放弃一个存储过程
SQL> DROP PROCEDURE skeleton;
Procedure dropped