case语句更新指定员工薪资

用户输入雇员姓名，使用case语句更新工资，10部门提高100,20部门提高200,30部门提高300,40部门提高400

DECLARE  C_CUR_ROW EMP.DEPTNO%TYPE;BEGIN  SELECT DEPTNO INTO C_CUR_ROW FROM EMP WHERE ename='SMITH';  CASE    WHEN C_CUR_ROW = '10' THEN      UPDATE EMP A SET A.SAL = A.SAL + 100;    WHEN C_CUR_ROW = '20' THEN      UPDATE EMP A SET A.SAL = A.SAL + 200;    WHEN C_CUR_ROW = '30' THEN      UPDATE EMP A SET A.SAL = A.SAL + 300;  END CASE;END;