Uncategorized – Learning is not a spectator sport

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

Normally I don’t dedicate a post to just a podcast episode, because you can see them all here, but since

Just a quick blog post today showing how easy it was for me to upgrade from ORDS 22.1 to the

I threw this little puzzle out on Twitter just before the New Year It was a little bit mischievous of

Happy New Year to all! With the next long term release (23c) probably due some time this year, let’s start

Well, its been quite a year 🙂 Probably the highlight for me, and I’m sure for many others, was the

Somewhere around version 9 (maybe before, maybe later…all so long ago 😀) the distinction between CLOB and VARCHAR2 became less

I had an inquiry about the performance of DBMS_PARALLEL_EXECUTE today from a customer. Whilst the utility (as the name suggests)

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