plsql – Learning is not a spectator sport

Cloning a schema with one line

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

There’s a hesitation to publish this example, because publishing it may be interpreted as an endorsement of this approach and

Here’s a simple little PL/SQL block where we call an inner procedure PARAMETER_TESTER from its parent block. Pay particular attention