Learning is not a spectator sport

Implementing dynamic partitions AND subpartitions

One of the cool things to come out of the partitioning option many moons ago was the feature known as

What happens when you want to serenade your partner with a romantic ditty, but you’re a database professional as well?

So I started all of this by talking about how PLSQL is going to give you a performance boost, just

So after my post yesterday about PL/SQL being a no-brainer to get an easy boost to application performance, there was

I rarely blog about PLSQL for a very simple reason. It quickly becomes like Halloween night because all the ghouls

Just a quick tip on using DBMS_METADATA that caught me out the other day. If you have a table and

Handling default values on columns has been an age old problem that we solved in 12c with extensions to the

I tweeted this snippet the other day because to be honest I was just overjoyed about being able to get

Nearly 10 years ago(!!!) I blogged about how you can toggle columns to invisible and back again as a means

The database on my laptop seemed slow this morning. Normally I would put this down to the fact that I’ve