(一)系统异常
-- Created on 2020/4/22 by ADMINISTRATOR
declare
-- Local variables here
c_manager constant number:=0.2;
c_saleman constant number:=0.15;
c_clerk constant number:=0.1;
v_job varchar(100);
v_empno number;
--empno1 number;
begin
-- Test statements here
v_empno := &empno1;
select job into v_job from scott.emp where empno=v_empno;
if v_job='CLERK' then
update scott