I have in the past struggled with the myriad of formatting options available with dbms_xplan.display_cursor so I was pleased to learn about a quick and easy to remember way of formatting the results at this years UKOUG conference. First execute the SQL statement of interest including the gather_plan_statistics hint: Then run dbms_xplan.display_cursor: The key point is …

Continue reading

In this article I will demonstrate several different methods you can use to perform XSLT from within PL/SQL. The examples were built using Oracle Database 11.2.0.1.0 and SQL Developer 3.2 The examples are based on this XML document…. and this XSLT document…. XMLTRANSFORM OK, so the first example is actually SQL rather than PL/SQL! XMTRANSFORM is a SQL Function …

Continue reading