Learning is not a spectator sport

The Fractional Part of a TIMESTAMP. Be careful.

This discovery came in from an AskTom customer but I figured it’s worth passing on to any PL/SQL programmers out

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