plan.sql

rem Example of create rows in PLAN_TABLE
explain plan
set statement_id='JACK'
    into plan_table
    for select * from v_contract;

rem plan.sql - displays contents of the explain plan table
set pages 9999;
select 	lpad(' ',2*(level-1))||operation operation,
		options, 
		object_name, 
		position
from plan_table
start with id=0 
and 
statement_id = 'JACK'
connect by prior id = parent_id
and
statement_id = 'JACK';