📄 5.29.txt
字号:
CREATE OR REPLACE PROCEDURE query_sal
(eno VARCHAR2,name OUT VARCHAR 2,salary IN OUT NUMBER)
IS
v_sal NUMBER;
BEGIN
SELECT employeename,sal INTO name,v_sal
FROM employee WHERE employeeno=eno;
salary:=salary+v_sal;
EXCEPTION
WHEN NO_DATA_FOUND THEN
raise_application_error(-20000,'该雇员不存在');
END query_sal;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -