SeekU

EXPLAIN PLAN FOR

SELECT DEPARTMENT_ID, MANAGER_ID FROM EMPLOYEES

GROUP BY DEPARTMENT_ID, MANAGER_ID ;

SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);

jsp 파일 반영안되는 경우 : _generated_/~/jeus_jspwork => rm -rf *  실행

로그파일 지우기 : /stdcli/EDFS/logs/년도/날짜 => rm -rf * 실행

용량확인방법 : df -h, df -m

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;