EXPLAIN PLAN
set statement_id = 'AAA'
into educ07.plan_table
for select ename
from emp
where ename like 'S%'
EXPLAIN PLAN
set statement_id = 'AAA'
into educ07.plan_table
for select *
from NATION N,BORDER B
where N.CODE = B.desc NATION_CODE
select sysdate from dual
DELETE FROM educ07.PLAN_TABLE
WHERE STATEMENT_ID = 'AAA'
set statement_id = 'AAA'
into educ07.plan_table
for select ename
from emp
where ename like 'S%'
EXPLAIN PLAN
set statement_id = 'AAA'
into educ07.plan_table
for select *
from NATION N,BORDER B
where N.CODE = B.desc NATION_CODE
select sysdate from dual
DELETE FROM educ07.PLAN_TABLE
WHERE STATEMENT_ID = 'AAA'