--- title: "Connor McDonald (@connormcdonald) | Hashnode" description: "I help people succeed with the Oracle Database. Read the latest articles by Connor McDonald on Hashnode." url: "https://hashnode.com/@connormcdonald" --- @connormcdonald # Connor McDonald @connormcdonald · Perth, Australia · Joined April 2022 I help people succeed with the Oracle Database [Website](http://connor-mcdonald.com/) ### [Faster operations with CLOBs](https://connormcdonald.hashnode.dev/faster-operations-with-clobs?utm_source=hashnode&utm_medium=feed) 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, ... 4 min read · [connormcdonald.hashnode.dev](https://connormcdonald.hashnode.dev/faster-operations-with-clobs?utm_source=hashnode&utm_medium=feed) [Dec 6, 2022](https://hashnode.com/posts/faster-operations-with-clobs/638f05b8483ccb28bb24ecae) ### [The cost of DBMS\_PARALLEL\_EXECUTE](https://connormcdonald.hashnode.dev/the-cost-of-dbmsparallelexecute?utm_source=hashnode&utm_medium=feed) 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 ... 4 min read · [connormcdonald.hashnode.dev](https://connormcdonald.hashnode.dev/the-cost-of-dbmsparallelexecute?utm_source=hashnode&utm_medium=feed) [Nov 30, 2022](https://hashnode.com/posts/the-cost-of-dbmsparallelexecute/638d9d7b42749fea21df1504) ### [Google-like search for your entire application](https://connormcdonald.hashnode.dev/google-like-search-for-your-entire-application?utm_source=hashnode&utm_medium=feed) 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... 5 min read · [connormcdonald.hashnode.dev](https://connormcdonald.hashnode.dev/google-like-search-for-your-entire-application?utm_source=hashnode&utm_medium=feed) [Nov 23, 2022](https://hashnode.com/posts/google-like-search-for-your-entire-application/638d9cff64aa8f0cc9c481f2) ### [I did not write this blog post](https://connormcdonald.hashnode.dev/i-did-not-write-this-blog-post?utm_source=hashnode&utm_medium=feed) 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... 3 min read · [connormcdonald.hashnode.dev](https://connormcdonald.hashnode.dev/i-did-not-write-this-blog-post?utm_source=hashnode&utm_medium=feed) [Nov 11, 2022](https://hashnode.com/posts/i-did-not-write-this-blog-post/638d9cb2e215ab4394fcc811) ### [From stateful to stateless PL/SQL](https://connormcdonald.hashnode.dev/from-stateful-to-stateless-plsql?utm_source=hashnode&utm_medium=feed) 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 ... 6 min read · [connormcdonald.hashnode.dev](https://connormcdonald.hashnode.dev/from-stateful-to-stateless-plsql?utm_source=hashnode&utm_medium=feed) [Nov 9, 2022](https://hashnode.com/posts/from-stateful-to-stateless-plsql/638d9b34e215ab4394fcc80d)