developer – Page 2 – Learning is not a spectator sport

From stateful to stateless PL/SQL

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

For some giggles this Halloween, over on Twitter I tweeted some worst practices each hour during Halloween in the guise

One of the cool things with the native SQL handling of complex datatypes is the ability to take something like

As many readers will be aware, we introduced a cool new JSON datatype in 21c which offers more features and

For the many cases, simply having an EXPLAIN PLAN function will do the job when it comes to tuning SQL.

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

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