Many thanks.
- Vlad Sadilovskiy <vlovsky_at_gmail.com> wrote:
> No need to be rude. You can create custom procedure
> to concatenate and
> stream output from "select * from
> table(dbms_xplan.display)" into a single
> blob value.
>
> If you don't need a single value use:
>
> create table xplan_output as
> select * from table(dbms_xplan.display);
>
> - Vlad
>
> On 6/22/06, Stephen Barr <ascaroth969_at_yahoo.co.uk>
> wrote:
> >
> > How can I capture DBMS_XPLAN.DISPLAY output into a
> > table - e.g. as a CLOB?
> >
> > select * from table(dbms_xplan.display);
> >
> >
> >
> >
>
> > All New Yahoo! Mail – Tired of Vi_at_gr@! come-ons?
> Let our SpamGuard protect
> > you. http://uk.docs.yahoo.com/nowyoucan.html
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre.
http://uk.security.yahoo.com
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 22 2006 - 10:48:23 CDT
