explain.sql

--
-- Title :       explain.sql 
-- Description : Produce an explain plan.
-- 
-- Usage/Notes : 
-- 
-- Copyright :   ABCdba.com 2008 
-- 
 
SELECT
   LPAD( ' ' , 2*LEVEL )||operation||' '||options||' '||object_name
   EXPLAIN_PLAN
FROM
   plan_table
CONNECT BY
   PRIOR id = parent_id
START WITH
   id = 1
/

© copyright 2001-2014 ABCdba.com | all rights reserved