Connor McDonald on Database and SQL
LightNews LightNews
banner
connormcd.bsky.social
Connor McDonald on Database and SQL
@connormcd.bsky.social
1.1K followers 240 following 14K 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 Replies Media Videos
connormcd.bsky.social
Blast from the past. From file names to directory hierarchy. https://connor-mcdonald.com/2018/05/14/from-file-names-to-directory-hierarchy/
October 6, 2026 at 6:08 PM
connormcd.bsky.social
We're 16 days in ... 84 to go :-)
www.youtube.com/watch?v=Nx7F...
100 Features in 100 days ! #database #sql
YouTube video by SQL and Database explained!
www.youtube.com
October 6, 2026 at 2:42 PM
connormcd.bsky.social
Good things happen when you put your reading glasses on and keep an eye on the intsy wintsy fonts on screen 😀 @oracleapex #orclapex oracleapex.com
October 6, 2026 at 8:19 AM
connormcd.bsky.social
Many developers and DBAs know that the *EXPLAIN* PLAN command might not tell you the full story...but sometimes even the FINAL execution plan might not be a true representation of how your database actually executed the query.
youtu.be/uqknOzqd00E
When The Execution Plan Lies! (Not Just the Explain Plan)
YouTube video by SQL and Database explained!
youtu.be
October 6, 2026 at 5:23 AM
connormcd.bsky.social
Previously on the blog. Oracle Database 18c. https://connor-mcdonald.com/2018/02/17/oracle-database-18c/
October 5, 2026 at 6:08 PM
connormcd.bsky.social
The easy way to plan your AI World...use AI!

Here's the database-focussed itinerary it suggested. If you're coming to AI World, pop over to the demo booths and say Hi!

If you want a copy of the itinerary, you can grab it from my blog connor-mcdonald.com/2026/10/05/m...
October 5, 2026 at 2:34 AM
connormcd.bsky.social
Previously on the blog. Trip down memory lane. https://connor-mcdonald.com/2018/03/21/trip-down-memory-lane/
October 4, 2026 at 6:08 PM
Reposted by Connor McDonald on Database and SQL
robpike.io
Zero is my favorite speed for in-flight WiFi.
October 2, 2026 at 9:49 PM
connormcd.bsky.social
From the vault. Software quality - Grok and my friend's boat. https://connor-mcdonald.com/2026/01/04/software-quality-grok-and-my-friends-boat/
October 3, 2026 at 6:08 PM
connormcd.bsky.social
Previously on the blog. Interval partitioning just got better. https://connor-mcdonald.com/2017/08/01/interval-partitioning-just-got-better/
October 2, 2026 at 6:08 PM
connormcd.bsky.social
Blast from the past. PL/SQL in 21c gets amazing new loop iterators. https://connor-mcdonald.com/2021/01/15/pl-sql-in-21c-gets-amazing-new-loop-iterators/
October 1, 2026 at 6:08 PM
connormcd.bsky.social
Fresh SQLcl !
www.oracle.com/database/sql...
October 1, 2026 at 1:31 AM
connormcd.bsky.social
Blog greatest hits :-) . Disabled EZCONNECT. https://connor-mcdonald.com/2019/03/06/disabled-ezconnect
September 30, 2026 at 6:08 PM
connormcd.bsky.social
Blog greatest hits :-) . A new dictionary view for privileges. https://connor-mcdonald.com/2022/02/06/a-new-dictionary-view-for-privileges/
September 29, 2026 at 6:08 PM
connormcd.bsky.social
Why does the database let us choose a size for our extents? Does the size even matter? What happens if we get it wrong? Do we need to worry about it at all? Let's look at the evolution of storage settings in the Oracle Database

youtu.be/k5SGOu8nQXo
Choosing Your Database Storage Sizes
YouTube video by SQL and Database explained!
youtu.be
September 29, 2026 at 10:05 AM
connormcd.bsky.social
Blast from the past. Cleaner DDL than DBMS_METADATA. https://connor-mcdonald.com/2022/03/02/cleaner-ddl-than-dbms_metadata/
September 28, 2026 at 6:08 PM
connormcd.bsky.social
Session times are now out for AI World. Start planning your sessions today, and I'll see you there!

reg.rf.oracle.com/flow/oracle/...
September 28, 2026 at 7:10 AM
connormcd.bsky.social
Previously on the blog. Testing versus the Database. https://connor-mcdonald.com/2021/11/22/testing-versus-the-database/
September 27, 2026 at 6:08 PM
connormcd.bsky.social
Blog greatest hits :-) . NVL vs COALESCE. https://connor-mcdonald.com/2018/02/13/nvl-vs-coalesce/
September 26, 2026 at 6:08 PM
connormcd.bsky.social
Previously on the blog. Safeguard your APEX workspaces and applications. https://connor-mcdonald.com/2024/08/07/safeguard-your-apex-workspaces-and-applications/
September 25, 2026 at 6:08 PM
connormcd.bsky.social
Blog greatest hits :-) . Not using binds .. banging an obsolete drum?. https://connor-mcdonald.com/2016/01/20/not-using-binds-banging-an-obsolete-drum
September 24, 2026 at 6:08 PM
connormcd.bsky.social
Retro blog post. MERGE and ORA-8006. https://connor-mcdonald.com/2019/06/29/merge-and-ora-8006
September 23, 2026 at 6:08 PM
connormcd.bsky.social
Quick heads up to make sure your Oracle AI skill definitions are nice and fresh!
connor-mcdonald.com/2026/09/23/s...
Syncing your Oracle AI skill definitions
One of the very cool facilities in more recent versions of SQLcl is the skills command. The reason I like the command is that most of us have tinkered with various different harnesses such as Claud…
connor-mcdonald.com
September 23, 2026 at 9:49 AM
connormcd.bsky.social
Blog greatest hits :-) . ROWNUM and ORDER BY. https://connor-mcdonald.com/2018/02/28/rownum-and-order-by/
September 22, 2026 at 6:08 PM
connormcd.bsky.social
Retro blog post. Twas the night before log4j. https://connor-mcdonald.com/2021/12/22/twas-the-night-before-log4j/
September 21, 2026 at 6:08 PM