Cheeky Cockatoo

Life Advice and Stories, Travel, Oracle Tech, Good Food and More

plan.sql

Download Script

col query_plan for a80
accept statement_id char prompt 'Statement ID > '
select lpad(' ',2*(level-1))||operation||' '||' '||options||' '||object_name||' '||decode(id,0,'cost = '||position) query_plan
from plan_table
start with id = 1 and statement_id = '&&statement_id'
connect by prior id = parent_id and statement_id = '&&statement_id'
/