Connor McDonald on Database and SQL

Blog greatest hits :-) . BULK COLLECT into nested table. https://connor-mcdonald.com/2016/10/24/bulk-collect-into-nested-table

Retro blog post. IRR function in PLSQL. https://connor-mcdonald.com/2018/11/26/irr-function-in-plsql

Literally just hours after I hit "Post".... I swear folks were waiting for me in the shadows :-)

Previously on the blog. Partial Indexes? Take Care With Truncate. https://connor-mcdonald.com/2018/10/05/partial-indexes-take-care-with-truncate

The CloudWorld session catalog is out there!
reg.rf.oracle.com/flow/oracle/...

Blog greatest hits :-) . The APEX PSE christmas present!. https://connor-mcdonald.com/2020/12/21/the-apex-pse-christmas-present/

Never a good slide to have caught on camera 😂

YouTube video by SQL and Database explained! The Wrong Error from DROP IF EXISTS ?

New video! When you run the DROP IF EXISTS command, the database does not give any clues about whether it found an object to drop or not. That is a deliberate decision - here's why.

youtu.be/jGFp1YDZrws

Blog greatest hits :-) . When re-ordering columns is warranted. https://connor-mcdonald.com/2022/03/22/when-re-ordering-columns-is-warranted/

Love me some fresh new database goodness!

Transactions on LiveSQL Just a quick gotcha that often catches me out on LiveSQL, so posting it here to make sure you also don’t get caught out. (Quick Segue: If you’ve only used LiveSQL in the past, be sure t…

If you've only used LiveSQL in the past, be sure to check it out again - it has been totally re-jigged give a much more modern experience

connor-mcdonald.com/2025/08/04/t...

Blast from the past. When you screw up ... make it positive for your users. https://connor-mcdonald.com/2018/04/17/when-you-screw-up-make-it-positive-for-your-users/

Please.... if you're vibe coding something up, make it secure

Blast from the past. Why being wrong can be awesome. https://connor-mcdonald.com/2017/10/20/why-being-wrong-can-be-awesome/

Blast from the past. Expertise might not be the way forward. https://connor-mcdonald.com/2020/04/15/expertise-might-not-be-the-way-forward/

This weekend, why not check out the ACE program?
@oracleace.bsky.social
ace.oracle.com

A bit of Python and SQL will take you a long way

Blog greatest hits :-) . Amped on Amper. https://connor-mcdonald.com/2016/02/29/amped-on-amper

YouTube video by SQL and Database explained! Using SQL to Improve my Swimming

New vid! Can a little SQL help improve me from a sluggish swimmer into a streamlined one?
youtu.be/7GSUpJSVeCs
#database #sql

Reading this as I scroll social media tells me I'm failing...🤦

Renowned for their technical mastery and passion for community engagement, Oracle ACEs are dedicated to sharing their insights wherever innovation happens. This August, you’ll find ACEs presenting at a variety of events. ♠️
Check out the list 👉
blogs.oracle.com/ace/post/ora...
#OracleACE

poug?

Motherfucking wind farms…

Retro blog post. Index Compression. https://connor-mcdonald.com/2024/12/06/kris-kringle-the-database-index-compression/

Previously on the blog. Granular detail from a summary. https://connor-mcdonald.com/2016/06/24/granular-detail-from-a-summary

Flint Finishes Replacing 11,000 Lead Pipes, Concluding Activists' Decade-Long Effort to Secure Clean Water A decade after lead-contaminated water was found in Flint's water system, the legal battle to replace lead water pipes is nearly finished.

All the lead pipes in Flint, Michigan have been replaced, save for abandoned houses or those whose owners opted out of the free pipe replacement. This is the work of so many people who spread the word and showed up over and over again to hold Michigan accountable for the replacement project.

From the vault. 23ai -Leave Your Wallet at Home. https://connor-mcdonald.com/2024/05/04/23ai-leave-your-wallet-at-home/

"My name is Connor McDonald and I have walked through the airport gin section without making a purchase "... Thank you for your support through this difficult time

Padlocks on every door 🤣

The first 100% effective HIV prevention drug is approved and going global An epidemic that's been sustained for 44 years might finally be quelled, with the milestone approval of the first HIV drug that offers 100% protection with its twice-yearly injections. It's a landmark...

Well, I'll be damned.

It's royalty free and there's already six, generic manufacturers lined up.

newatlas.com/infectious-d...