developer – Learning is not a spectator sport

Avoiding INSERT glitches with SQL*Plus and SQLcl

Sometimes in data centric applications, we want to store metadata (such as HTML or CSS or other such text) in

New year and I knew you want some new news about new forums! (That’s a lot of “new” 😀) I’ll

I published a video today showing how to use a Text index to pick up search terms from multiple tables

In fact…no-one wrote this blog post! Here’s a little bit of fun for you. I was doing my normal doom

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