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