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);
Subscribe to:
Post Comments (Atom)
Followers
Blog Archive
-
▼
2009
(56)
-
▼
May
(9)
- ORACLE STATISTICS_LEVEL
- RMAN Restore From New Catalog location...........
- SGA_TARGET vs SGA_MAX_SIZE
- Understanding Shared Memory and Semaphores
- Oradebug
- How To Generate EXPLAIN PLAN
- Analyzing Tables, Indexes, and Clusters
- hOW to find most resource consuming statement in O...
- Virtual Private Database
-
▼
May
(9)
About Me
- Rohit
- N.Delhi, Delhi, India
- I am an Oracle Certified Professional, Oracle 9i/10G DBA, having 4+ years of core DBA experience.
No comments:
Post a Comment