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.
Somewhere around version 9 (maybe before, maybe later…all so long ago 😀) the distinction between CLOB and VARCHAR2 became less defined. This was a good thing because the typical operations you would do with a VARCHAR2, for example, SUBSTR, REPLACE, ...
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 up a large task into smaller chunks and then run those in parallel, the customer asked what was the ...
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 entire application or even your entire database. The video walks through a lot of background on how Tex...
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 advertisement that claimed an AI engine could write my blog posts for me! So I went to the site, typed in...
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 your applications. This advice has been valid for as long as PL/SQL has existed. And PL/SQL has been ...
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 I’d share a security horror story that I encountered with a customer recently. I’d love to say that I...
For some giggles this Halloween, over on Twitter I tweeted some worst practices each hour during Halloween in the guise of carved pumpkins. Here’s the complete set spanning the 24 hours – hopefully you do not recognise any of these in your data centr...
Just a quick post with a few highlights from CloudWorld, but really this is all about getting you the slides from my presentations, because I know it can be frustrating when they don’t appear for a long time on the official CloudWorld pages. So here’...
I suspect Joel would have kittens if he knew I would use the appreciation day to talk about Excel instead of APEX but courtesy of an AskTom question I stumbled across this cool little tool for accessing data from your autonomous database via Excel. Y...
