Learning is not a spectator sport

Connor McDonald

Connor McDonald

13 followers

Hi I'm Connor McDonald. I love playing with and exploring the Oracle database. But most of all I like seeing people succeed with the technology.

Faster operations with CLOBs

Dec 6, 20224 min read

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

Faster operations with CLOBs

The cost of DBMS_PARALLEL_EXECUTE

Nov 30, 20224 min read

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

The cost of DBMS_PARALLEL_EXECUTE

Google-like search for your entire application

Nov 23, 20225 min read

I published a video today showing how to use a Text index to pick up search terms from multiple tables to allow a “Google-like” search across your...

Google-like search for your entire application

I did not write this blog post

Nov 11, 20223 min read

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

I did not write this blog post

From stateful to stateless PL/SQL

Nov 9, 20226 min read

I’ve done a lot of talks mainly around the tremendous performance benefits you can get just by employing a little bit of PL/SQL in the core parts of...

From stateful to stateless PL/SQL

A Security Disaster

Nov 2, 20223 min read

There has been a lot of coverage here in Australia recently about one of our popular telco’s getting hacked due to a lapse in security. So I thought...

A Security Disaster