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
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