datatypes – Learning is not a spectator sport

Column names you should NOT use

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

I’ve got two words to describe my thoughts on being lazy with data types …. JUST DON’T! There’s been many

We all know that comparing two VARCHAR2 fields of different lengths will be treated by Oracle as being not EQUAL: