corpus.blog
41554 blogs · [ { "id": "01a0d7b0-6371-7079-8210-eacd26fc342c", "title": "Syncing your Oracle AI skill definitions", "url": "https://connor-mcdonald.com/2026/09/23/syncing-your-oracle-ai-skill-definitions/", "published_at": "2026-09-23T09:48:18+00:00" }, { "id": "01a0b0b9-7504-7295-97cd-cd05929a366c", "title": "ORA-24369? Required callbacks? Broken binds?", "url": "https://connor-mcdonald.com/2026/09/17/ora-24369-required-callbacks-broken-binds/", "published_at": "2026-09-17T09:04:12+00:00" }, { "id": "01a094e7-bcf6-706b-ad2f-b51ab60ea974", "title": "The mystery magical pluggable database", "url": "https://connor-mcdonald.com/2026/09/11/the-mystery-magical-pluggable-database/", "published_at": "2026-09-11T05:08:56+00:00" }, { "id": "01a08763-42db-7010-908a-3918f4c62a81", "title": "Your insurance policy as a DBA", "url": "https://connor-mcdonald.com/2026/09/04/your-insurance-policy-as-a-dba/", "published_at": "2026-09-04T13:52:00+00:00" }, { "id": "01a08763-42db-7010-908a-3918f53725b1", "title": "Deciphering Date Differences with DATEDIFF", "url": "https://connor-mcdonald.com/2026/08/17/deciphering-date-differences-with-datediff/", "published_at": "2026-08-17T07:00:58+00:00" }, { "id": "01a08763-42db-7010-908a-3918f5f9ff40", "title": "“Where are my patches?!?!”", "url": "https://connor-mcdonald.com/2026/08/13/where-are-my-patches/", "published_at": "2026-08-13T02:27:49+00:00" }, { "id": "01a08763-42dc-73bf-bbff-dd4629064f4c", "title": "More Gooey-ness from GUIDs", "url": "https://connor-mcdonald.com/2026/08/05/more-gooey-ness-from-guids/", "published_at": "2026-08-05T05:16:37+00:00" }, { "id": "01a08763-42dc-73bf-bbff-dd46298e8800", "title": "APEX Collections – Taking More Control", "url": "https://connor-mcdonald.com/2026/08/03/apex-collections-taking-more-control/", "published_at": "2026-08-03T13:45:30+00:00" }, { "id": "01a08763-42dc-73bf-bbff-dd4629c367cc", "title": "Database Features – The Bullet Point Myth", "url": "https://connor-mcdonald.com/2026/07/30/database-features-the-bullet-point-myth/", "published_at": "2026-07-30T06:32:05+00:00" }, { "id": "01a08763-42dc-73bf-bbff-dd462ab308ec", "title": "The APEX_COLLECTIONS crash puzzler…", "url": "https://connor-mcdonald.com/2026/07/28/the-apex_collections-crash-puzzler/", "published_at": "2026-07-28T06:32:02+00:00" }, { "id": "01a08763-42dc-73bf-bbff-dd462b748bda", "title": "Not the post I was expecting", "url": "https://connor-mcdonald.com/2026/07/16/not-the-post-i-was-expecting/", "published_at": "2026-07-16T13:18:45+00:00" }, { "id": "01a08763-42dc-73bf-bbff-dd462bc86c8c", "title": "The “best” tool", "url": "https://connor-mcdonald.com/2026/07/13/the-best-tool/", "published_at": "2026-07-13T10:40:50+00:00" }, { "id": "01a08763-42dc-73bf-bbff-dd462cada749", "title": "Tip: Expanding a SQL statement", "url": "https://connor-mcdonald.com/2026/07/02/tip-expanding-a-sql-statement/", "published_at": "2026-07-02T05:22:55+00:00" }, { "id": "01a08763-42dc-73bf-bbff-dd462d7e7a4b", "title": "WITH clause gets a 26ai boost!", "url": "https://connor-mcdonald.com/2026/07/01/with-clause-gets-a-26ai-boost/", "published_at": "2026-07-01T04:55:36+00:00" }, { "id": "01a08763-42dc-73bf-bbff-dd462d98a5d2", "title": "The Goldilocks problem – Materialized Views", "url": "https://connor-mcdonald.com/2026/06/30/the-goldilocks-problem-materialized-views/", "published_at": "2026-06-30T00:58:27+00:00" }, { "id": "01a08763-42dc-73bf-bbff-dd462e0d5977", "title": "Blue Sky Programming – The Optimism Trap", "url": "https://connor-mcdonald.com/2026/06/26/blue-sky-programming-the-optimism-trap/", "published_at": "2026-06-26T05:05:28+00:00" }, { "id": "01a08763-42dc-73bf-bbff-dd462eaa26a0", "title": "Keeping your tech ego in check", "url": "https://connor-mcdonald.com/2026/06/08/keeping-your-tech-ego-in-check/", "published_at": "2026-06-07T17:52:18+00:00" }, { "id": "01a08763-42dc-73bf-bbff-dd462f074d04", "title": "First dabblings with APEXlang", "url": "https://connor-mcdonald.com/2026/05/27/first-dabblings-with-apexlang/", "published_at": "2026-05-27T04:13:11+00:00" }, { "id": "01a08763-42dc-73bf-bbff-dd462f8a0778", "title": "Vanishing objects; hello ORA-08103", "url": "https://connor-mcdonald.com/2026/05/13/vanishing-objects-hello-ora-08103/", "published_at": "2026-05-13T12:57:39+00:00" }, { "id": "01a08763-42dc-73bf-bbff-dd4630174003", "title": "A very robust query", "url": "https://connor-mcdonald.com/2026/05/12/a-very-robust-query/", "published_at": "2026-05-12T07:54:46+00:00" }, { "id": "01a08763-42dc-73bf-bbff-dd46302018ad", "title": "The secret APEX performance hack", "url": "https://connor-mcdonald.com/2026/05/08/6991/", "published_at": "2026-05-08T01:49:57+00:00" }, { "id": "01a08763-42dc-73bf-bbff-dd463037f91e", "title": "Signal to noise ratio – the AWR trap", "url": "https://connor-mcdonald.com/2026/05/06/signal-to-noise-ratio-the-awr-trap/", "published_at": "2026-05-06T04:33:47+00:00" }, { "id": "01a08763-42dc-73bf-bbff-dd46305e3537", "title": "The new release update experience", "url": "https://connor-mcdonald.com/2026/05/04/the-new-release-update-experience/", "published_at": "2026-05-04T07:34:04+00:00" }, { "id": "01a0c503-f72d-7282-8b47-744ac973f6f7", "title": "My APEX installer / patcher", "url": "https://connor-mcdonald.com/2026/05/01/my-apex-installer-patcher/", "published_at": "2026-05-01T02:47:17+00:00" }, { "id": "01a0c503-f72d-7282-8b47-744ac988faa6", "title": "The unhealthy obsession with ROLLBACK", "url": "https://connor-mcdonald.com/2026/04/30/the-unhealthy-obsession-with-rollback/", "published_at": "2026-04-30T06:52:23+00:00" }, { "id": "01a0c503-f72d-7282-8b47-744ac9d85289", "title": "Unleashing Skills onto my database", "url": "https://connor-mcdonald.com/2026/04/28/unleashing-skills-onto-my-database/", "published_at": "2026-04-28T02:20:07+00:00" }, { "id": "01a0c503-f72d-7282-8b47-744ac9e1952c", "title": "SQL skills just got MORE important", "url": "https://connor-mcdonald.com/2026/04/22/sql-skills-just-got-more-important/", "published_at": "2026-04-22T00:32:59+00:00" }, { "id": "01a0c503-f72d-7282-8b47-744acad56143", "title": "GROUP BY ALL – Is it ALL you ever need?", "url": "https://connor-mcdonald.com/2026/04/17/group-by-all-is-it-all-you-ever-need/", "published_at": "2026-04-17T01:54:12+00:00" }, { "id": "01a0c503-f72d-7282-8b47-744acb603ee8", "title": "Voxxed Days Zurich", "url": "https://connor-mcdonald.com/2026/04/07/voxxed-days-zurich/", "published_at": "2026-04-07T02:07:48+00:00" }, { "id": "01a0c503-f72d-7282-8b47-744acbcec4fe", "title": "Thank you after 21 years", "url": "https://connor-mcdonald.com/2026/03/12/thank-you-after-21-years/", "published_at": "2026-03-12T02:34:30+00:00" }, { "id": "01a0c503-f72d-7282-8b47-744acbf08d7c", "title": "Bind Variables – Worse than you were told", "url": "https://connor-mcdonald.com/2026/03/09/bind-variables-worse-than-you-were-told/", "published_at": "2026-03-09T08:12:41+00:00" }, { "id": "01a0c503-f72d-7282-8b47-744acc760b98", "title": "Where is my TNSPING?", "url": "https://connor-mcdonald.com/2026/03/05/why-is-my-tnsping/", "published_at": "2026-03-05T13:54:01+00:00" }, { "id": "01a0c503-f72d-7282-8b47-744acd169ae6", "title": "Generate INSERTs the new 26ai way", "url": "https://connor-mcdonald.com/2026/03/02/generate-inserts-the-new-26ai-way/", "published_at": "2026-03-02T14:22:24+00:00" }, { "id": "01a0c503-f72d-7282-8b47-744acda80135", "title": "INSERT-VALUES – Bigger is NOT always Better!", "url": "https://connor-mcdonald.com/2026/02/27/insert-values-bigger-is-not-always-better/", "published_at": "2026-02-27T08:40:18+00:00" }, { "id": "01a0c503-f72d-7282-8b47-744acddedd48", "title": "SQL Macros make so many things easier", "url": "https://connor-mcdonald.com/2026/02/19/sql-macros-make-so-many-things-easier/", "published_at": "2026-02-19T05:54:38+00:00" }, { "id": "01a0c503-f72d-7282-8b47-744aceb9a187", "title": "26ai Quick Tip for Database Links", "url": "https://connor-mcdonald.com/2026/01/29/26ai-quick-tip-for-database-links/", "published_at": "2026-01-29T00:05:58+00:00" }, { "id": "01a0c503-f72d-7282-8b47-744acf0a9d5f", "title": "Datatype Discipline – Even more so in 26ai", "url": "https://connor-mcdonald.com/2026/01/28/datatype-discipline-even-more-so-in-26ai/", "published_at": "2026-01-28T07:04:30+00:00" }, { "id": "01a0c503-f72d-7282-8b47-744acf1bf0f4", "title": "The new Boolean … What about existing apps?", "url": "https://connor-mcdonald.com/2026/01/23/the-new-boolean-what-about-existing-apps/", "published_at": "2026-01-23T08:05:28+00:00" }, { "id": "01a0c503-f72d-7282-8b47-744acf8f4e1a", "title": "What grabbed your attention in 2025", "url": "https://connor-mcdonald.com/2026/01/07/what-grabbed-your-attention-in-2025/", "published_at": "2026-01-07T02:10:24+00:00" }, { "id": "01a0c503-f72d-7282-8b47-744ad06b99ef", "title": "Software quality – Grok and my friend’s boat", "url": "https://connor-mcdonald.com/2026/01/04/software-quality-grok-and-my-friends-boat/", "published_at": "2026-01-04T02:31:07+00:00" }, { "id": "01a0c503-f72d-7282-8b47-744ad0a1a229", "title": "2025 … wrapped", "url": "https://connor-mcdonald.com/2025/12/30/2025-wrapped/", "published_at": "2025-12-30T01:15:36+00:00" }, { "id": "01a0c516-3379-72c4-8f14-f4234d9344a5", "title": "Transaction Priorities in 26ai – open season on locking", "url": "https://connor-mcdonald.com/2025/12/17/transaction-priorities-in-26ai-open-season-on-locking/", "published_at": "2025-12-17T07:41:01+00:00" }, { "id": "01a0c516-3379-72c4-8f14-f4234e8a8f70", "title": "An AI generated SQL for Christmas", "url": "https://connor-mcdonald.com/2025/12/12/an-ai-generated-sql-for-christmas/", "published_at": "2025-12-12T07:04:47+00:00" }, { "id": "01a0c516-3379-72c4-8f14-f4234ee9347c", "title": "The Christmas database", "url": "https://connor-mcdonald.com/2025/12/10/the-christmas-database/", "published_at": "2025-12-10T10:17:55+00:00" }, { "id": "01a0c516-3379-72c4-8f14-f4234fd54357", "title": "Virtualbox 7.2.4 upgrade … grrr", "url": "https://connor-mcdonald.com/2025/12/05/virtualbox-7-2-4-upgrade-grrr/", "published_at": "2025-12-05T04:47:51+00:00" }, { "id": "01a0c516-3379-72c4-8f14-f42350c5099e", "title": "Tuning SQL without any access", "url": "https://connor-mcdonald.com/2025/12/04/tuning-sql-without-any-access/", "published_at": "2025-12-04T13:32:05+00:00" }, { "id": "01a0c516-3379-72c4-8f14-f42351b1415d", "title": "APAC conferences wrap up", "url": "https://connor-mcdonald.com/2025/12/03/apac-conferences-wrap-up/", "published_at": "2025-12-03T03:32:41+00:00" }, { "id": "01a0c516-3379-72c4-8f14-f4235293dfa2", "title": "South Africa Oracle User Group conference was a blast!", "url": "https://connor-mcdonald.com/2025/12/02/south-africa-oracle-user-group-conference-was-a-blast/", "published_at": "2025-12-02T01:43:42+00:00" }, { "id": "01a0c516-3379-72c4-8f14-f42352f91c42", "title": "Turbo boost your LOBs and JSON", "url": "https://connor-mcdonald.com/2025/11/06/turbo-boost-your-lobs-and-json/", "published_at": "2025-11-06T10:03:38+00:00" }, { "id": "01a0c516-3379-72c4-8f14-f42353c3e018", "title": "XMLTYPE on Autonomous", "url": "https://connor-mcdonald.com/2025/10/31/xmltype-on-autonomous-2/", "published_at": "2025-10-31T08:01:28+00:00" }, { "id": "01a0c516-3379-72c4-8f14-f4235451011b", "title": "SQL trace on Autonomous", "url": "https://connor-mcdonald.com/2025/10/27/sql-trace-on-autonomous/", "published_at": "2025-10-27T07:54:15+00:00" }, { "id": "01a0c516-3379-72c4-8f14-f423553e8ae3", "title": "The AI World 2025 mega download!", "url": "https://connor-mcdonald.com/2025/10/21/the-ai-world-2025-mega-download/", "published_at": "2025-10-21T12:58:00+00:00" }, { "id": "01a0c516-3379-72c4-8f14-f42355f92eab", "title": "Wrapping up Oracle AI World", "url": "https://connor-mcdonald.com/2025/10/16/wrapping-up-oracle-ai-world/", "published_at": "2025-10-16T15:05:40+00:00" }, { "id": "01a0c516-3379-72c4-8f14-f42356dcec86", "title": "Security predicates exposed #JoelKallmanDay", "url": "https://connor-mcdonald.com/2025/10/15/security-predicates-exposed-joelkallmanday/", "published_at": "2025-10-15T00:15:38+00:00" }, { "id": "01a0c516-3379-72c4-8f14-f42357d8ac63", "title": "Soft Deletes via Partitioning", "url": "https://connor-mcdonald.com/2025/10/03/soft-deletes-via-partitioning/", "published_at": "2025-10-03T03:55:05+00:00" }, { "id": "01a0c516-3379-72c4-8f14-f423586fdb2a", "title": "My Session Picks for AI World – Thursday", "url": "https://connor-mcdonald.com/2025/10/01/my-session-picks-for-ai-world-thursday/", "published_at": "2025-10-01T02:29:58+00:00" }, { "id": "01a0c516-3379-72c4-8f14-f42358e320f7", "title": "My Session Picks for AI World – Wednesday", "url": "https://connor-mcdonald.com/2025/09/29/my-session-picks-for-ai-world-wednesday/", "published_at": "2025-09-29T03:14:43+00:00" }, { "id": "01a0c516-3379-72c4-8f14-f42359da720c", "title": "My Session Picks for AI World – Tuesday", "url": "https://connor-mcdonald.com/2025/09/26/my-session-picks-for-ai-world-tuesday/", "published_at": "2025-09-26T02:58:06+00:00" }, { "id": "01a0c516-3379-72c4-8f14-f4235a761198", "title": "My Session Picks for AI World – Monday", "url": "https://connor-mcdonald.com/2025/09/25/my-session-picks-for-ai-world-monday/", "published_at": "2025-09-25T04:14:16+00:00" }, { "id": "01a0c516-3379-72c4-8f14-f4235abb1322", "title": "The Moment for Database Documentation has come!", "url": "https://connor-mcdonald.com/2025/09/22/the-moment-for-database-documentation-has-come/", "published_at": "2025-09-22T13:09:43+00:00" }, { "id": "01a0c516-3379-72c4-8f14-f4235b18f835", "title": "MERGE in 23ai – so much more than RETURNING", "url": "https://connor-mcdonald.com/2025/09/18/merge-in-23ai-so-much-more-than-returning/", "published_at": "2025-09-18T05:34:08+00:00" }, { "id": "01a0c521-267c-70c8-b874-082cc2aeee1d", "title": "Low code is dead", "url": "https://connor-mcdonald.com/2025/09/06/low-code-is-dead/", "published_at": "2025-09-06T09:40:16+00:00" }, { "id": "01a0c521-267c-70c8-b874-082cc35f1525", "title": "Mixing and matching", "url": "https://connor-mcdonald.com/2025/09/02/mixing-and-matching/", "published_at": "2025-09-02T14:39:00+00:00" }, { "id": "01a0c521-267c-70c8-b874-082cc3ce2bc0", "title": "Troubleshooting External Scheduler Jobs", "url": "https://connor-mcdonald.com/2025/09/01/troubleshooting-external-scheduler-jobs/", "published_at": "2025-09-01T13:50:25+00:00" }, { "id": "01a0c521-267c-70c8-b874-082cc3d4c09a", "title": "AI World and the power of APEX", "url": "https://connor-mcdonald.com/2025/08/17/ai-world-and-the-power-of-apex/", "published_at": "2025-08-17T09:26:31+00:00" }, { "id": "01a0c521-267c-70c8-b874-082cc3fcd1d2", "title": "Quick tip for OpenAI on APEX", "url": "https://connor-mcdonald.com/2025/08/14/quick-tip-for-openai-on-apex/", "published_at": "2025-08-14T07:01:56+00:00" }, { "id": "01a0c521-267c-70c8-b874-082cc461b578", "title": "I got shamed into using AutoUpgrade", "url": "https://connor-mcdonald.com/2025/08/12/i-got-shamed-into-using-autoupgrade/", "published_at": "2025-08-12T04:13:07+00:00" }, { "id": "01a0c521-267c-70c8-b874-082cc542fc57", "title": "Transactions on LiveSQL", "url": "https://connor-mcdonald.com/2025/08/04/transactions-on-livesql/", "published_at": "2025-08-04T03:01:55+00:00" }, { "id": "01a0c521-267c-70c8-b874-082cc5e507c9", "title": "Pictorial highlights from Yatra 2025", "url": "https://connor-mcdonald.com/2025/08/01/pictorial-highlights-from-yatra-2025/", "published_at": "2025-08-01T03:13:36+00:00" }, { "id": "01a0c521-267c-70c8-b874-082cc64c7b8f", "title": "First dabblings with SQLcl MCP server", "url": "https://connor-mcdonald.com/2025/07/14/first-dabblings-with-sqlcl-mcp-server/", "published_at": "2025-07-14T03:43:19+00:00" }, { "id": "01a0c521-267c-70c8-b874-082cc673b491", "title": "Can you prioritise DDL locks?", "url": "https://connor-mcdonald.com/2025/07/14/can-you-prioritise-ddl-locks/", "published_at": "2025-07-14T02:42:58+00:00" }, { "id": "01a0c521-267c-70c8-b874-082cc698c28c", "title": "Are the Fundamentals Too Much to Ask?", "url": "https://connor-mcdonald.com/2025/07/06/are-the-fundamentals-too-much-to-ask/", "published_at": "2025-07-06T09:00:02+00:00" }, { "id": "01a0c521-268c-731a-9d64-654d7c9fa032", "title": "The junior programmer at your company might not be a human being", "url": "https://connor-mcdonald.com/2025/06/10/the-junior-programmer-at-your-company-might-not-be-a-human-being/", "published_at": "2025-06-09T19:43:13+00:00" }, { "id": "01a0c521-268c-731a-9d64-654d7cd9863c", "title": "The first 10 years", "url": "https://connor-mcdonald.com/2025/06/02/the-first-10-years/", "published_at": "2025-06-02T09:45:32+00:00" }, { "id": "01a0c521-268c-731a-9d64-654d7d201102", "title": "A new optimizer constant", "url": "https://connor-mcdonald.com/2025/05/27/a-new-optimizer-constant/", "published_at": "2025-05-27T01:57:21+00:00" }, { "id": "01a0c521-268c-731a-9d64-654d7da8777a", "title": "Database timezone versus OS timezone", "url": "https://connor-mcdonald.com/2025/05/21/database-timezone-versus-os-timezone/", "published_at": "2025-05-21T04:56:23+00:00" }, { "id": "01a0c521-268c-731a-9d64-654d7df3089a", "title": "Customizing the Oracle Documentation", "url": "https://connor-mcdonald.com/2025/05/20/customizing-the-oracle-documentation/", "published_at": "2025-05-20T02:34:48+00:00" }, { "id": "01a0c521-268d-727a-9581-fa59ec8e7878", "title": "In-Database SQL formatter", "url": "https://connor-mcdonald.com/2025/05/14/in-database-sql-formatter/", "published_at": "2025-05-14T10:48:09+00:00" }, { "id": "01a0c521-268d-727a-9581-fa59ed816c9d", "title": "Old style export/import and Autonomous", "url": "https://connor-mcdonald.com/2025/05/12/old-style-export-import-and-autonomous/", "published_at": "2025-05-12T12:28:47+00:00" }, { "id": "01a0c521-268d-727a-9581-fa59eded283a", "title": "AWR extract – Why did SYSAUX explode?", "url": "https://connor-mcdonald.com/2025/05/07/awr-extract-why-did-sysaux-explode/", "published_at": "2025-05-07T07:13:28+00:00" }, { "id": "01a0c521-268d-727a-9581-fa59eec223a0", "title": "Statistics on Global Temporary Tables", "url": "https://connor-mcdonald.com/2025/05/06/statistics-on-global-temporary-tables/", "published_at": "2025-05-06T04:42:02+00:00" }, { "id": "01a0c52c-7965-708b-884b-c71f9e31d150", "title": "Smashing a database on my PC", "url": "https://connor-mcdonald.com/2025/05/05/smashing-a-database-on-my-pc/", "published_at": "2025-05-05T13:15:57+00:00" }, { "id": "01a0c52c-7965-708b-884b-c71f9e4497df", "title": "APPEND_VALUES redux – Why Community Matters", "url": "https://connor-mcdonald.com/2025/05/01/append_values-redux-why-community-matters/", "published_at": "2025-05-01T07:32:53+00:00" }, { "id": "01a0c52c-7966-7258-bbc3-c52ad18a6d06", "title": "Calling out LinkedIn Clickbait", "url": "https://connor-mcdonald.com/2025/04/30/calling-out-linkedin-clickbait/", "published_at": "2025-04-30T07:38:41+00:00" }, { "id": "01a0c52c-7966-7258-bbc3-c52ad21e82e6", "title": "APEX 24 exports – PL/SQL and SQLcl", "url": "https://connor-mcdonald.com/2025/04/28/apex-24-exports-pl-sql-and-sqlcl/", "published_at": "2025-04-28T06:32:37+00:00" }, { "id": "01a0c52c-7966-7258-bbc3-c52ad3044f5c", "title": "You can’t beat FREE STUFF !", "url": "https://connor-mcdonald.com/2025/04/25/you-cant-beat-free-stuff/", "published_at": "2025-04-25T01:43:08+00:00" }, { "id": "01a0c52c-7966-7258-bbc3-c52ad3305eeb", "title": "Can you REALLY drop those columns?", "url": "https://connor-mcdonald.com/2025/04/23/can-you-really-drop-those-columns/", "published_at": "2025-04-23T00:17:28+00:00" }, { "id": "01a0c52c-7966-7258-bbc3-c52ad3a8cbb7", "title": "UNION versus UNION ALL", "url": "https://connor-mcdonald.com/2025/04/22/union-versus-union-all/", "published_at": "2025-04-22T14:24:09+00:00" }, { "id": "01a0c52c-7966-7258-bbc3-c52ad3afa614", "title": "Don’t jump on that Zoom call … at least not right away", "url": "https://connor-mcdonald.com/2025/04/10/dont-jump-on-that-zoom-call-at-least-not-right-away/", "published_at": "2025-04-10T07:14:41+00:00" }, { "id": "01a0c52c-7966-7258-bbc3-c52ad3f5a135", "title": "Spaghetti code is Good code", "url": "https://connor-mcdonald.com/2025/04/03/spaghetti-code-is-good-code/", "published_at": "2025-04-03T05:52:29+00:00" }, { "id": "01a0c52c-7966-7258-bbc3-c52ad4c70692", "title": "More Features just by Patching", "url": "https://connor-mcdonald.com/2025/03/31/more-features-just-by-patching/", "published_at": "2025-03-31T06:21:19+00:00" }, { "id": "01a0c52c-7966-7258-bbc3-c52ad5a34131", "title": "Global Temporary Tables and Dynamic Sampling", "url": "https://connor-mcdonald.com/2025/03/25/global-temporary-tables-and-dynamic-sampling/", "published_at": "2025-03-25T13:33:21+00:00" }, { "id": "01a0c52c-7966-7258-bbc3-c52ad64557f6", "title": "Vectors in Oracle Database 23ai FREE", "url": "https://connor-mcdonald.com/2025/03/10/vectors-in-oracle-database-23ai-free/", "published_at": "2025-03-10T03:21:44+00:00" }, { "id": "01a0c52c-7966-7258-bbc3-c52ad6cc14f2", "title": "International Women’s Day", "url": "https://connor-mcdonald.com/2025/03/08/international-womens-day/", "published_at": "2025-03-08T00:14:46+00:00" }, { "id": "01a0c52c-7966-7258-bbc3-c52ad717b105", "title": "Sequences in PL/SQL", "url": "https://connor-mcdonald.com/2025/03/04/sequences-in-pl-sql/", "published_at": "2025-03-04T00:22:34+00:00" }, { "id": "01a0c52c-7966-7258-bbc3-c52ad80ae62d", "title": "The APEX data dictionary", "url": "https://connor-mcdonald.com/2025/02/26/the-apex-data-dictionary/", "published_at": "2025-02-26T04:55:41+00:00" }, { "id": "01a0c52c-7966-7258-bbc3-c52ad871d208", "title": "Understanding REUSE STORAGE", "url": "https://connor-mcdonald.com/2025/02/25/understanding-reuse-storage/", "published_at": "2025-02-25T07:26:27+00:00" }, { "id": "01a0c52c-7966-7258-bbc3-c52ad873a156", "title": "Creating rows from nothing – time for something better", "url": "https://connor-mcdonald.com/2025/02/19/creating-rows-from-nothing-time-for-something-better/", "published_at": "2025-02-19T03:38:17+00:00" }, { "id": "01a0c52c-7966-7258-bbc3-c52ad8967894", "title": "JSON_OBJECT_T and the PGA", "url": "https://connor-mcdonald.com/2025/02/17/json_object_t-and-the-pga/", "published_at": "2025-02-17T04:30:27+00:00" }, { "id": "01a0c52c-7966-7258-bbc3-c52ad8af43d5", "title": "More zero outage goodies", "url": "https://connor-mcdonald.com/2025/01/30/more-zero-outage-goodies/", "published_at": "2025-01-30T04:06:04+00:00" } ] posts Claim your blog
Back to connor-mcdonald.com
Blog · corpus.blog/blogs/connor-mcdonald.com/posts

connor-mcdonald.com

connor-mcdonald.com

2026

Syncing your Oracle AI skill definitionsoriginal ↗
23 Sept 2026
ORA-24369? Required callbacks? Broken binds?original ↗
17 Sept 2026
The mystery magical pluggable databaseoriginal ↗
11 Sept 2026
Your insurance policy as a DBAoriginal ↗
4 Sept 2026
Deciphering Date Differences with DATEDIFForiginal ↗
17 Aug 2026
“Where are my patches?!?!”original ↗
13 Aug 2026
More Gooey-ness from GUIDsoriginal ↗
5 Aug 2026
APEX Collections – Taking More Controloriginal ↗
3 Aug 2026
Database Features – The Bullet Point Mythoriginal ↗
30 Jul 2026
The APEX_COLLECTIONS crash puzzler…original ↗
28 Jul 2026
Not the post I was expectingoriginal ↗
16 Jul 2026
The “best” tooloriginal ↗
13 Jul 2026
Tip: Expanding a SQL statementoriginal ↗
2 Jul 2026
WITH clause gets a 26ai boost!original ↗
1 Jul 2026
The Goldilocks problem – Materialized Viewsoriginal ↗
30 Jun 2026
Blue Sky Programming – The Optimism Traporiginal ↗
26 Jun 2026
Keeping your tech ego in checkoriginal ↗
7 Jun 2026
First dabblings with APEXlangoriginal ↗
27 May 2026
Vanishing objects; hello ORA-08103original ↗
13 May 2026
A very robust queryoriginal ↗
12 May 2026
The secret APEX performance hackoriginal ↗
8 May 2026
Signal to noise ratio – the AWR traporiginal ↗
6 May 2026
The new release update experienceoriginal ↗
4 May 2026
My APEX installer / patcheroriginal ↗
1 May 2026
The unhealthy obsession with ROLLBACKoriginal ↗
30 Apr 2026
Unleashing Skills onto my databaseoriginal ↗
28 Apr 2026
SQL skills just got MORE importantoriginal ↗
22 Apr 2026
GROUP BY ALL – Is it ALL you ever need?original ↗
17 Apr 2026
Voxxed Days Zurichoriginal ↗
7 Apr 2026
Thank you after 21 yearsoriginal ↗
12 Mar 2026
Bind Variables – Worse than you were toldoriginal ↗
9 Mar 2026
Where is my TNSPING?original ↗
5 Mar 2026
Generate INSERTs the new 26ai wayoriginal ↗
2 Mar 2026
INSERT-VALUES – Bigger is NOT always Better!original ↗
27 Feb 2026
SQL Macros make so many things easieroriginal ↗
19 Feb 2026
26ai Quick Tip for Database Linksoriginal ↗
29 Jan 2026
Datatype Discipline – Even more so in 26aioriginal ↗
28 Jan 2026
The new Boolean … What about existing apps?original ↗
23 Jan 2026
What grabbed your attention in 2025original ↗
7 Jan 2026
Software quality – Grok and my friend’s boatoriginal ↗
4 Jan 2026

2025

2025 … wrappedoriginal ↗
30 Dec 2025
Transaction Priorities in 26ai – open season on lockingoriginal ↗
17 Dec 2025
An AI generated SQL for Christmasoriginal ↗
12 Dec 2025
The Christmas databaseoriginal ↗
10 Dec 2025
Virtualbox 7.2.4 upgrade … grrroriginal ↗
5 Dec 2025
Tuning SQL without any accessoriginal ↗
4 Dec 2025
APAC conferences wrap uporiginal ↗
3 Dec 2025
South Africa Oracle User Group conference was a blast!original ↗
2 Dec 2025
Turbo boost your LOBs and JSONoriginal ↗
6 Nov 2025
XMLTYPE on Autonomousoriginal ↗
31 Oct 2025
SQL trace on Autonomousoriginal ↗
27 Oct 2025
The AI World 2025 mega download!original ↗
21 Oct 2025
Wrapping up Oracle AI Worldoriginal ↗
16 Oct 2025
Security predicates exposed #JoelKallmanDayoriginal ↗
15 Oct 2025
Soft Deletes via Partitioningoriginal ↗
3 Oct 2025
My Session Picks for AI World – Thursdayoriginal ↗
1 Oct 2025
My Session Picks for AI World – Wednesdayoriginal ↗
29 Sept 2025
My Session Picks for AI World – Tuesdayoriginal ↗
26 Sept 2025
My Session Picks for AI World – Mondayoriginal ↗
25 Sept 2025
The Moment for Database Documentation has come!original ↗
22 Sept 2025
MERGE in 23ai – so much more than RETURNINGoriginal ↗
18 Sept 2025
Low code is deadoriginal ↗
6 Sept 2025
Mixing and matchingoriginal ↗
2 Sept 2025
Troubleshooting External Scheduler Jobsoriginal ↗
1 Sept 2025
AI World and the power of APEXoriginal ↗
17 Aug 2025
Quick tip for OpenAI on APEXoriginal ↗
14 Aug 2025
I got shamed into using AutoUpgradeoriginal ↗
12 Aug 2025
Transactions on LiveSQLoriginal ↗
4 Aug 2025
Pictorial highlights from Yatra 2025original ↗
1 Aug 2025
First dabblings with SQLcl MCP serveroriginal ↗
14 Jul 2025
Can you prioritise DDL locks?original ↗
14 Jul 2025
Are the Fundamentals Too Much to Ask?original ↗
6 Jul 2025
The junior programmer at your company might not be a human beingoriginal ↗
9 Jun 2025
The first 10 yearsoriginal ↗
2 Jun 2025
A new optimizer constantoriginal ↗
27 May 2025
Database timezone versus OS timezoneoriginal ↗
21 May 2025
Customizing the Oracle Documentationoriginal ↗
20 May 2025
In-Database SQL formatteroriginal ↗
14 May 2025
Old style export/import and Autonomousoriginal ↗
12 May 2025
AWR extract – Why did SYSAUX explode?original ↗
7 May 2025
Statistics on Global Temporary Tablesoriginal ↗
6 May 2025
Smashing a database on my PCoriginal ↗
5 May 2025
APPEND_VALUES redux – Why Community Mattersoriginal ↗
1 May 2025
Calling out LinkedIn Clickbaitoriginal ↗
30 Apr 2025
APEX 24 exports – PL/SQL and SQLcloriginal ↗
28 Apr 2025
You can’t beat FREE STUFF !original ↗
25 Apr 2025
Can you REALLY drop those columns?original ↗
23 Apr 2025
UNION versus UNION ALLoriginal ↗
22 Apr 2025
Don’t jump on that Zoom call … at least not right awayoriginal ↗
10 Apr 2025
Spaghetti code is Good codeoriginal ↗
3 Apr 2025
More Features just by Patchingoriginal ↗
31 Mar 2025
Global Temporary Tables and Dynamic Samplingoriginal ↗
25 Mar 2025
Vectors in Oracle Database 23ai FREEoriginal ↗
10 Mar 2025
International Women’s Dayoriginal ↗
8 Mar 2025
Sequences in PL/SQLoriginal ↗
4 Mar 2025
The APEX data dictionaryoriginal ↗
26 Feb 2025
Understanding REUSE STORAGEoriginal ↗
25 Feb 2025
Creating rows from nothing – time for something betteroriginal ↗
19 Feb 2025
JSON_OBJECT_T and the PGAoriginal ↗
17 Feb 2025
More zero outage goodiesoriginal ↗
30 Jan 2025
Next