Connor McDonald on Database and SQL

The biggest highlight of conferences is never the tech, but the chance to meet, catch up, and chat face to face with peers from around the world. It's selfie time with the Best...Community....Ever. #OracleAIWorld

From the vault. External table preprocessor on Windows. https://connor-mcdonald.com/2019/03/08/external-table-preprocessor-on-windows

YouTube video by SQL and Database explained! JSON_TRANSFORM is magic!

New video! I went to some sessions at Oracle AI World covering our JSON functionality. What you can do with JSON_TRANSFORM is next level amazing! Here's just a tiny part of the awesomeness.
youtu.be/RHZLbdEoSug

Blog greatest hits :-) . V$SESSION_LONGOPS and parallel query. https://connor-mcdonald.com/2022/02/11/vsession_longops-and-parallel-query/

The AI World 2025 mega download! We’ve all been there… You head over to the Session Catalog for AI World and you want to download the files for all of the sessions you have been to, and all of the sessions you have missed. Then yo…

Missed some sessions at @OracleAIWorld? Here's the 2025 mega download of session content. Enjoy!
connor-mcdonald.com/2025/10/21/t...

From the vault. Safeguard your APEX workspaces and applications. https://connor-mcdonald.com/2024/08/07/safeguard-your-apex-workspaces-and-applications/

Blast from the past. Hack-a-Mongo. https://connor-mcdonald.com/2017/01/09/hack-a-mongo

My Session Picks for AI World – Thursday Some people think “Since Thursday is a half day I’ll skip it” but some of the best content of the conference will be on Thursday. In particular, one of my favourite speakers Nigel…

Let's bring AI world home with a bang! Session picks for Thursday
connor-mcdonald.com/2025/10/01/m...

All this vector stuff totally new to you? This 20min session will help! @OracleDatabase @OracleAIWorld

Oracle APEX Reactive Markdown Plug-in #JoelKallmanDay Display rich Markdown in Oracle APEX that reacts to changes of referenced page items.

For #JoelKallmanDay I am sharing a free plug-in for reactive Markdown preview. It auto refreshes, supports tables, alerts, etc., and comes with three themes. #orclAPEX

hartenfeller.dev/blog/apex-re...

My Session Picks for AI World – Wednesday Well, there might be a touch of bias here, but there is definitely one session you must have on your agenda for Wednesday at AI World. In fact, if you go this session in the official catalog you ca…

My session picks for Wednesday at @OracleAIWorld
connor-mcdonald.com/2025/09/29/m...

Your 26ai Free database is waiting for you ... Just a couple of commands to be up and running! #OracleAIWorld

Security predicates exposed #JoelKallmanDay

connor-mcdonald.com/2025/10/15/s...

Deck of SQL tips cards

Deck of SQL tips cards

Get your desks of #SQL tips at #AIWorld from the swag-as-a-service or Oracle AI Database booths

Good morning @OracleAIWorld !

Here's some cool sessions for today
connor-mcdonald.com/2025/09/26/m...

The problem with having a monster monitor at the home office, is that when you travel with a laptop you suddenly realise that you are basically blind

The horn in India is more "hey just letting you know I am here" than the more aggressive use case in other countries

Great conference.. even better country

I will see you just in time for the sessions on Nov 17 😁

Fabulous weather in the small time in Sydney on way to AI World

Retro blog post. 18c and the ignoring of hints. https://connor-mcdonald.com/2018/11/21/18c-and-the-ignoring-of-hints

23 things to do at AI World

23 things to do at AI World

This is your chance to shape what products we build, how we build them, and what features they should have ... Take the Oracle DB Developer Survey 2025 and share your insights:

customersurveys.oracle.com/ords/surveys...

What's the old saying:

"Most AI is just sed, awk and grep" :-)

Previously on the blog. Cool stuff with partition elimination. https://connor-mcdonald.com/2018/03/12/cool-stuff-with-partition-elimination/

When your "Zero Slides" session requires you to have a QR code for the post-event survey 😂 #SQL #FTW

bit.ly/aiworld23ai

Woo hoo! Fresh update! Just in time for @OracleAIWorld ❤️‍🔥

Retro blog post. Not using binds .. banging an obsolete drum?. https://connor-mcdonald.com/2016/01/20/not-using-binds-banging-an-obsolete-drum