datatypes – Learning is not a spectator sport

XMLTABLE and data “corruption”

One of the cool things with the native SQL handling of complex datatypes is the ability to take something like

Just a little bit of Friday fun with PL/SQL data types for this post. Let’s explore the performance differences when

We all know from our data modelling days… (Sidenote: Remember those days? You know…when we used to think about good

There has always been that odd conflict between the language you use for SQL versus the language you use for

Perhaps the most famous (or infamous) performance tuning problem you’ll find spanning decades of blog posts when it comes to

Just a quick post to ensure people don’t get caught out by a recent “trick” I saw on an AskTOM

Here’s a quirky one for you. It can happen when you are dealing with a partitioned table where the partition

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

Here’s an interesting little oddity (aka bug) with scalar queries. We’ll start with a simple working example SQL> create table

Just a quick post here by request of an attendee of the September Office Hours. I had a demo converting