Connor McDonald on Database and SQL
LightNews LightNews
banner
connormcd.bsky.social
Connor McDonald on Database and SQL
@connormcd.bsky.social
1K followers 240 following 13K posts
Hi I'm Connor McDonald! 🔥keen on tech esp. SQL/database 🔥keen on fitness 🔥keen on coffee 🔥keen on gin 🔥keen on sarcasm I speak for me not my employer
Posts Media Videos Starter Packs
connormcd.bsky.social
Connor McDonald on Database and SQL @connormcd.bsky.social · 12h
Blog greatest hits :-) . A SQL conundrum. https://connor-mcdonald.com/2024/05/20/a-sql-conundrum/
connormcd.bsky.social
Connor McDonald on Database and SQL @connormcd.bsky.social · 22h
SQL trace on Autonomous database
connor-mcdonald.com/2025/10/27/s...
SQL trace on Autonomous
I’ve blogged before about activating SQL trace on autonomous database, but here’s a little addenda that you might appreciate. Lets assume I’ve done the setup as described in the b…
connor-mcdonald.com
1 6
connormcd.bsky.social
Connor McDonald on Database and SQL @connormcd.bsky.social · 1d
Blog greatest hits :-) . Bitten by the leap year?. https://connor-mcdonald.com/2024/03/07/bitten-by-the-leap-year/
1
connormcd.bsky.social
Connor McDonald on Database and SQL @connormcd.bsky.social · 2d
Blog greatest hits :-) . A little bit of PLSQL and a little bit of network. https://connor-mcdonald.com/2022/04/12/a-little-bit-of-plsql-and-a-little-bit-of-network/
1
connormcd.bsky.social
Connor McDonald on Database and SQL @connormcd.bsky.social · 3d
Blog greatest hits :-) . CLOBs are not just big varchars. https://connor-mcdonald.com/2015/12/03/clobs-are-not-just-big-varchars
1
connormcd.bsky.social
Connor McDonald on Database and SQL @connormcd.bsky.social · 4d
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
8
connormcd.bsky.social
Connor McDonald on Database and SQL @connormcd.bsky.social · 4d
From the vault. External table preprocessor on Windows. https://connor-mcdonald.com/2019/03/08/external-table-preprocessor-on-windows
1
connormcd.bsky.social
Connor McDonald on Database and SQL @connormcd.bsky.social · 5d
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
JSON_TRANSFORM is magic!
YouTube video by SQL and Database explained!
youtu.be
2
connormcd.bsky.social
Connor McDonald on Database and SQL @connormcd.bsky.social · 5d
Blog greatest hits :-) . V$SESSION_LONGOPS and parallel query. https://connor-mcdonald.com/2022/02/11/vsession_longops-and-parallel-query/
1
connormcd.bsky.social
Connor McDonald on Database and SQL @connormcd.bsky.social · 6d
Missed some sessions at @OracleAIWorld? Here's the 2025 mega download of session content. Enjoy!
connor-mcdonald.com/2025/10/21/t...
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…
connor-mcdonald.com
3 7
connormcd.bsky.social
Connor McDonald on Database and SQL @connormcd.bsky.social · 6d
From the vault. Safeguard your APEX workspaces and applications. https://connor-mcdonald.com/2024/08/07/safeguard-your-apex-workspaces-and-applications/
connormcd.bsky.social
Connor McDonald on Database and SQL @connormcd.bsky.social · 7d
Blast from the past. Hack-a-Mongo. https://connor-mcdonald.com/2017/01/09/hack-a-mongo
connormcd.bsky.social
Connor McDonald on Database and SQL @connormcd.bsky.social · 11d
Let's bring AI world home with a bang! Session picks for Thursday
connor-mcdonald.com/2025/10/01/m...
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…
connor-mcdonald.com
2
connormcd.bsky.social
Connor McDonald on Database and SQL @connormcd.bsky.social · 12d
All this vector stuff totally new to you? This 20min session will help! @OracleDatabase @OracleAIWorld
Reposted by Connor McDonald on Database and SQL
hartenfeller.dev
Philipp Hartenfeller @hartenfeller.dev · 13d
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...
Oracle APEX Reactive Markdown Plug-in #JoelKallmanDay
Display rich Markdown in Oracle APEX that reacts to changes of referenced page items.
hartenfeller.dev
1 6 14
connormcd.bsky.social
Connor McDonald on Database and SQL @connormcd.bsky.social · 12d
My session picks for Wednesday at @OracleAIWorld
connor-mcdonald.com/2025/09/29/m...
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…
connor-mcdonald.com
1
connormcd.bsky.social
Connor McDonald on Database and SQL @connormcd.bsky.social · 13d
Your 26ai Free database is waiting for you ... Just a couple of commands to be up and running! #OracleAIWorld
2 3
connormcd.bsky.social
Connor McDonald on Database and SQL @connormcd.bsky.social · 13d
Security predicates exposed #JoelKallmanDay

connor-mcdonald.com/2025/10/15/s...
1 5
Reposted by Connor McDonald on Database and SQL
chrisrsaxon.bsky.social
Chris Saxon @chrisrsaxon.bsky.social · 13d
Get your desks of #SQL tips at #AIWorld from the swag-as-a-service or Oracle AI Database booths
Deck of SQL tips cards Deck of SQL tips cards
2 5
connormcd.bsky.social
Connor McDonald on Database and SQL @connormcd.bsky.social · 13d
Good morning @OracleAIWorld !

Here's some cool sessions for today
connor-mcdonald.com/2025/09/26/m...
2
connormcd.bsky.social
Connor McDonald on Database and SQL @connormcd.bsky.social · 15d
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
3 14
connormcd.bsky.social
Connor McDonald on Database and SQL @connormcd.bsky.social · 16d
The horn in India is more "hey just letting you know I am here" than the more aggressive use case in other countries
1
connormcd.bsky.social
Connor McDonald on Database and SQL @connormcd.bsky.social · 16d
Great conference.. even better country
2
connormcd.bsky.social
Connor McDonald on Database and SQL @connormcd.bsky.social · 16d
I will see you just in time for the sessions on Nov 17 😁
1
connormcd.bsky.social
Connor McDonald on Database and SQL @connormcd.bsky.social · 16d
Fabulous weather in the small time in Sydney on way to AI World
1 1