set linesize 80

select lpad(' ',2*level)||operation||' '||options
           ||' '||object_name query_plan
from   plan_table
connect by prior id = parent_id 
start with id = 1
/

