18c versus 19c
I had someone say to me at an event recently: “We’re are going to upgrade to 18c, because 19c is
Tag: plsql
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
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
