Uncategorized – Learning is not a spectator sport

Quick Tip on Datapatch

When I patch my databases through the various Release Updates, I normally do a blog post showing how easy and

I took a quick glance at the schedule for Tuesday for CloudWorld and realised I’m going to need to clone

Finding interesting data to improve your SQL skills can be a nuisance. There are of course plenty of freely available

After attending a talk by Mike Dietrich at the DOAG conference, I was pleasantly surprised to hear that in 21c,

I’ve just got back from the DOAG conference, and what a fantastic event it was. I know I’m considered a

When the “STORE IN” clause is mentioned for partitioned tables, most people’s mind turn toward hash partitioning, because the usage

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

Here’s something to be careful with when it comes to using DBMS_REDEFINITION. Let’s start with the following scenario. I have

Well….that blew up! 😀 Last week I published a video (which you can watch below if you haven’t seen it)

At my physical design talk at this year’s Yatra tour in India, one of the demos I do is multiple