set feedback off;
set echo off;
accept queryname prompt 'Enter Statement ID: ';
Select lpad(' ', 2* (level-1))||operation||' '||options||
 ' '||object_name||' '|| decode (id,0, 'Cost = '|| position)
 "Execution Plan"
 from plan_table
 start with id=0
    and statement_id='&queryname'
 connect by prior id = parent_id
    and statement_id = '&queryname';
set feedback on;
set echo on
/