XMLTABLE and data “corruption”
One of the cool things with the native SQL handling of complex datatypes is the ability to take something like
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