Capturing DBMS_XPLAN.DISPLAY output

  • From: Stephen Barr <ascaroth969@xxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 22 Jun 2006 11:19:42 +0100 (BST)

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: