Many thanks.

--- Vlad Sadilovskiy <vlovsky@(protected):

> 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@(protected)>
> 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@gr@(protected)?
> 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