Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: explain plan from pl/sql ?

Re: explain plan from pl/sql ?

From: Thomas Wagner <twa_priv_at_yahoo.com>
Date: 5 Nov 2003 21:48:28 -0800
Message-ID: <f695d6a3.0311052148.7a3abcea@posting.google.com> 





idogan_tech_at_yahoo.com (Ibrahim DOGAN) wrote in message news:<6bf58828.0311050646.44eb8cbb_at_posting.google.com>...


> is it possible to run "explain plan" command within a PL/SQL block ?

> 

> thanks,

> i.d.




What about this:



begin


  execute immediate 'explain plan for select * from dual';
end;


/



Regards


Thomas
Received on Wed Nov 05 2003 - 23:48:28 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US