使用PLSQL完成功能

请使用PLSQL完成对SCOTT的emp表中的员工，按照不同的工作岗位类型，进行涨工资的操作CLERK 涨幅500块ANALYST 涨幅1000块MANAGER 涨幅8%其他岗位涨幅5%create or replace procedure test_pc as    cursor emp1_cur is        select empno, job from emp1;    type emp1_rec_type is record(        l_empno emp1.empno%type,        l_job   emp1.job%type);    emp1_rec emp1_rec_type;begin    open emp1_cur;    loop        fetch emp1_cur            into emp1_rec;        exit when emp1_cur%notfound;        if emp1_rec.l_job = 'CLERK' then            update emp1 set sal = sal + 500 where empno = emp1_rec.l_empno;        elsif emp1_rec.l_job = 'ANALYST' then            update emp1               set sal = sal + 1000             where empno = emp1_rec.l_empno;        elsif emp1_rec.l_job = 'MANAGER' then            update emp1               set sal = sal + sal * 0.08             where empno = emp1_rec.l_empno;        else            update emp1               set sal = sal * 1.05             where empno = emp1_rec.l_empno;            commit;        end if;    end loop;    close emp1_cur;end;