2 Comments

  1. 12/16/2013

    Hi Marco,

    As you’ve found out, those techniques have been floating around for quite some time now.
    On recent releases, I’d probably replace the whole thing with a single XMLCAST call :

    SELECT XMLCast(
             XMLAgg(XMLElement(e, output)) 
             AS CLOB
           ) 
    FROM TABLE( dbms_feature_usage_report.display_html );
  2. 12/16/2013

    You are right ;-) (tried it just now on 12.1)

    Works perfectly as well AND it gets rid of the old propriety extract stuff AND wrong encoding.

    Thanks Marc!

    PS.
    As you hinted a bit (“on recent releases”), I would be careful with XMLAGG/XMLCAST in 11.1

Comments are closed.