开发者

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

开发者 https://www.devze.com 2023-03-08 21:53 出处:网络
Rephrasing the question: Are this two code snippets different in any way? CREATE OR REPLAC开发者_开发百科E PROCEDURE

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

精彩评论

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