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@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@gr@! come-ons? Let our SpamGuard protect you. http://uk.docs.yahoo.com/nowyoucan.html
--
http://www.freelists.org/webpage/oracle-l