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

+ Recent posts