Re: explain plan from pl/sql ?

Ibrahim DOGAN wrote:

>is it possible to run "explain plan" command within a PL/SQL block ?
>
>thanks,
>i.d.
>
>

Yes. Absolutely. Look at the built-in package DBMS_XPLAN.

You guys need to take my class at the U. ;-)

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)