UTL_FILE_DIR and 18c revisited
A couple of years back (wow…time flies!) I made a video and a post about the de-support of UTL_FILE_DIR in
Tag: plsql
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
The definition of proof
One of the pieces of advice that I often see on the ‘net is that undo space is somehow this
Same dog, different leash – functions in SQL
Let’s start with this somewhat odd looking result. I have an inline function that returns a random number between 0
SMON_SCN_TIME and ORA-8161? Digging deeper
In the recent versions of the Oracle database, we’ve had the ability to convert between a System Change Number (SCN)
With and without WITH_PLSQL within a WITH SQL statement
OK, let’s be honest right up front. The motivation for this post is solely to be able to roll out
Generic data models … generic applications … ugh
There’s a hesitation to publish this example, because publishing it may be interpreted as an endorsement of this approach and
