Monday, May 11, 2009

How To Generate EXPLAIN PLAN

EXPLAIN PLAN
SET STATEMENT_ID = 'Raise in Tokyo' {STATEMENT_ID Can be any integer or text}
INTO plan_table
FOR UPDATE employees
SET salary = salary * 1.10
WHERE department_id =
(SELECT department_id FROM departments
WHERE location_id = 1200);

No comments:

Post a Comment

Followers

About Me

My photo
N.Delhi, Delhi, India
I am an Oracle Certified Professional, Oracle 9i/10G DBA, having 4+ years of core DBA experience.