Uncategorized – Page 4 – Learning is not a spectator sport

PL/SQL – choosing the BEST data type

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

Rather than bore you with a lengthy tome about the event, I’d thought I would summarise the week with pictures

Ask an Oracle practitioner what DBMS_METADATA is used for, and they’ll (correctly) tell you it used to retrieve the DDL

The recyclebin is a very cool feature in the Oracle Database, and a great “Get of our jail free” card

In 12c, we introduced a feature call Row Archival, which is a means of integrating typical archival models that we

Full disclosure: This is a rant post. If you’re not into ranting and pontificating, perhaps best to move along now

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