Oracle
rowid
시크유
2017. 2. 14. 20:59
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;