plsql – Learning is not a spectator sport

Code re-use … Not a substitute for brain use

I was doing some code review today of a PL/SQL package, and came across a routine to generate a list

This one just for fun today. An AskTOM question came in about arbitrary length arithmetic because “NUMBER(38) was not enough”.

I had an AskTOM question come in with an issue trying to PL/SQL on an Active Data Guard (ADG) database

I had someone say to me at an event recently: “We’re are going to upgrade to 18c, because 19c is

A couple of years back (wow…time flies!) I made a video and a post about the de-support of UTL_FILE_DIR in

In the world of DevOps, continuous integration and repeatable test cases, the demand for being able to quickly build a

One of the pieces of advice that I often see on the ‘net is that undo space is somehow this

Let’s start with this somewhat odd looking result. I have an inline function that returns a random number between 0

In the recent versions of the Oracle database, we’ve had the ability to convert between a System Change Number (SCN)

OK, let’s be honest right up front. The motivation for this post is solely to be able to roll out