CREATE OR REPLACE PROCEDURE SELECTEMP(P_EMPNO IN NUMBER DEFAULT 7369) AS
V_ENAME EMP.ENAME%TYPE;
BEGIN
SELECT E.ENAME INTO V_ENAME FROM EMP E WHERE E.EMPNO=P_EMPNO;
DBMS_OUTPUT.put_line(V_ENAME);
END SELECTEMP;
BEGIN
SELECTEMP(7499);
END;
BEGIN
SELECTEMP();--默认参数值
END;
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024