Doc

     Name:    explain.sql

     Provides the execution path of a statement after you have
     placed data into the plan_table using the EXPLAIN PLAN 
     facility

#


SELECT LPAD(‘ ‘, 2*level) || operation ||’ ‘ || 
         options ||’ ‘ || object_name "Execution Plan"
  FROM plan_table
CONNECT BY PRIOR id = parent_id
  START WITH ID = 1;