Re: explain plan from pl/sql ?

From: mcstock <mcstockspamplug_at_spamdamenquery.com>
Date: Thu, 6 Nov 2003 07:53:13 -0500
Message-ID: <ecKdnYRoOPL32TeiRVn-jA@comcast.com>

good catch, thomas

and the reason is that, although EXPLAIN PLAN is typically issues via SQL*Plus, it is not a SQL*Plus command, but a legal SQL statement -- but since it is not a DML statement, it is not directly supported by PL/SQL

"Thomas Wagner" <twa_priv_at_yahoo.com> wrote in message news:f695d6a3.0311052148.7a3abcea_at_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 Thu Nov 06 2003 - 06:53:13 CST