Oracle/PLSQL: Creating Procedures:
[url]http://www.techonthenet.com/oracle/procedures.php[/url][quote]The syntax for a procedure is:
[/quote]其中的IS也可以是AS,没有区别。扩展开来:
[url]http://stackoverflow.com/questions/230348/what-is-the-difference-between-as-and-is-in-an-oracle-stored-procedure[/url]
在定义procedures和packages时as和is是可以通用的;但定义cursors时只能用is。
[url]http://www.techonthenet.com/oracle/procedures.php[/url][quote]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];
[/quote]其中的IS也可以是AS,没有区别。扩展开来:
[url]http://stackoverflow.com/questions/230348/what-is-the-difference-between-as-and-is-in-an-oracle-stored-procedure[/url]
在定义procedures和packages时as和is是可以通用的;但定义cursors时只能用is。