Hi Tom, 

Need help extracting execution plan  for  any anonymous PL/SQL block . 

I am able to extract execution plan for SQL using explain plan but it doesn't work for pl/sql block 


EXPLAIN PLAN FOR 
select * from dual; 

select * from plan_table 



--we are trying extract execution plan for all quries inside a block 





DECLARE 

 l_date DATE; 

BEGIN 

 select sysdate 

 INTO l_Date 

 FROM DUAL; 

 DBMS_OUTPUT.put_line (l_date); 



 --this block will have multiple queries 


END; 

/ 


Can you please help ? 

Thanks , 
Tanu