开发者

Are parameters in a PL/SQL Stored Procedure "IN" by default?

Rephrasing the question: Are this two code snippets different in any way?

CREATE OR REPLAC开发者_开发百科E PROCEDURE 
ASSIGN_EMAIL(E_NO INT, F_NAME VARCHAR2, L_NAME VARCHAR2)

CREATE OR REPLACE PROCEDURE 
ASSIGN_EMAIL(E_NO IN INT, F_NAME IN VARCHAR2, L_NAME IN VARCHAR2)


Yes, IN is the default. Check table 8.1 in the Oracle PL/SQL subprogram docs.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜