DECLARE
v_sal emp_test_t.sal%TYPE;
BEGIN
SELECT sal INTO v_sal
FROM emp_test_t
WHERE empno = 7369;
CASE
WHEN v_sal > 1000 THEN
v_sal := v_sal*1.2;
DBMS_OUTPUT.PUT_LINE('v_sal := v_sal*1.2');
WHEN v_sal > 900 THEN
v_sal := v_sal*1.3;
DBMS_OUTPUT.PUT_LINE('v_sal := v_sal*1.3');
WHEN v_sal > 800 THEN
v_sal := v_sal*1.4;
DBMS_OUTPUT.PUT_LINE('v_sal := v_sal*1.4');
ELSE
v_sal := v_sal*1.6;
DBMS_OUTPUT.PUT_LINE('v_sal := v_sal*1.6');
END CASE;
UPDATE emp_test_t set sal = v_sal
WHERE empno = 7369;
END;
/
----------------------------------------------------------------
DECLARE
e_sal NUMBER;
BEGIN
SELECT sal INTO e_sal
FROM emp
WHERE empno = 7369;
e_sal:= CASE
WHEN e_sal > 1000 THEN e_sal *1.2
WHEN e_sal > 900 THEN e_sal* 1.3
WHEN e_sal > 800 THEN e_sal * 1.4
ELSE e_sal*1.6
END ;
UPDATE emp SET sal = e_sal WHERE empno = 7369 ;
END;
/
댓글
댓글 쓰기