In this article I will explain the method I use when I need to process an indeterminate number of rows using PL/SQL. I became aware of this method after reading Bryn Llewellyn’s white paper Doing SQL From PL/SQL: Best and Worst Practises (My example is based on the code shown on page 31 of the white paper) […]
“It was working yesterday…” Working in any form of shared development environment you will sooner or later hit a problem when something that used to work has either stopped working or is doing something it wasn’t doing before. So how do you find out what have changed? With regards PL/SQL objects such as Packages, Triggers […]
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 […]
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 […]
This post was inspired by a comment on Martin Windlake’s blog. I am an Oracle Developer who actually likes reading technical books, not only about Oracle technologies but also the wider Software Development world. (Does that put me in a minority?) As a self taught programmer I have read many Oracle books since I started working […]
iancarpenter.dev 
You must be logged in to post a comment.