📄 5.7.txt
字号:
DECLARE
v_job VARCHAR2(10);
v_sal NUMBER(6,2);
BEGIN
SELECT postno,sal into v_job,v_sal
FROM employee WHERE employeeno=&&no;
IF v_job='001' THEN
UPDATE employee SET sal=v_sal+200 WHERE employeeno=&no;
ELSIF v_job='002' THEN
UPDATE employee SET sal=v_sal+100 WHERE employeeno=&no;
ELSE
UPDATE employee SET sal=v_sal+50 WHERE employeeno=&no;
END IF;
END;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -