datatypes – Learning is not a spectator sport

HIGH_VALUE (and other LONG columns) revisited

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:

There’s a somewhat sour discussion going on based attached to the video at https://www.youtube.com/watch?v=jZW-uLb52xk Whether you agree or disagree with

(This is based on some ‘issues’ a client was having, so the example is architected to make a particular point,