plsql – Learning is not a spectator sport

SQL engine and PL/SQL functions

A common pattern I see in database code is the use of a PL/SQL package to hold constants to be

Somewhere around version 9 (maybe before, maybe later…all so long ago 😀) the distinction between CLOB and VARCHAR2 became less

I’ve done a lot of talks mainly around the tremendous performance benefits you can get just by employing a little

Just a little bit of Friday fun with PL/SQL data types for this post. Let’s explore the performance differences when

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