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;