DECLARE
V_ROWID ROWID;
V_SALARY NUMBER;
BEGIN
SELECT ROWID, SALARY
INTO V_ROWID, V_SALARY
FROM EMPLOYEES
WHERE FIRST_NAME = 'Steven'
AND LAST_NAME = 'Kind'
UPDATE EMPLOYEES SET SALARY = V_SALARY * 1.1
WHERE ROWID = V_ROWID;
END;
'Oracle' 카테고리의 다른 글
실행계획 (0) | 2017.03.06 |
---|---|
START WITH CONNECT BY (0) | 2017.02.23 |
OVER PARTITION BY (0) | 2017.02.22 |
EXISTS (0) | 2017.02.21 |
EXPLAIN PLAN FOR (0) | 2017.02.20 |