Oracle Procedure 存储过程

Oracle/PLSQL: Creating Procedures:
http://www.techonthenet.com/oracle/procedures.php

引用

The syntax for a procedure is:

CREATE [OR REPLACE] PROCEDURE procedure_name
    [ (parameter [,parameter]) ]
IS
    [declaration_section]
BEGIN
    executable_section
[EXCEPTION
    exception_section]
END [procedure_name];

其中的IS也可以是AS，没有区别。扩展开来：
http://stackoverflow.com/questions/230348/what-is-the-difference-between-as-and-is-in-an-oracle-stored-procedure
在定义procedures和packages时as和is是可以通用的；但定义cursors时只能用is。