2 Comments

  1. December 16

    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. December 16

    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.