corpus.blog
41554 blogs · [ { "id": "01a0c52c-7966-7258-bbc3-c52ad9647cb4", "title": "JDBC and the FetchSize – Part 2", "url": "https://connor-mcdonald.com/2025/01/28/jdbcand-the-fetchsize-part-2/", "published_at": "2025-01-28T14:36:41+00:00" }, { "id": "01a0c537-7526-710f-a6f5-27b5bc2f1a29", "title": "JDBC, the FetchSize and staying up to date", "url": "https://connor-mcdonald.com/2025/01/17/jdbc-the-fetchsize-and-staying-up-to-date/", "published_at": "2025-01-17T04:32:20+00:00" }, { "id": "01a0c537-7526-710f-a6f5-27b5bc772d34", "title": "DataPump – niche fix", "url": "https://connor-mcdonald.com/2025/01/15/datapump-niche-fix/", "published_at": "2025-01-15T04:19:52+00:00" }, { "id": "01a0c537-7526-710f-a6f5-27b5bc8a9ca7", "title": "OPatch – The “File In Use” error that wasn’t", "url": "https://connor-mcdonald.com/2025/01/07/opatch-the-file-in-use-error-that-wasnt/", "published_at": "2025-01-07T03:26:17+00:00" }, { "id": "01a0c537-7526-710f-a6f5-27b5bd802af3", "title": "The year in numbers", "url": "https://connor-mcdonald.com/2024/12/31/the-year-in-numbers/", "published_at": "2024-12-31T07:45:11+00:00" }, { "id": "01a0c537-7526-710f-a6f5-27b5bddfcfe2", "title": "Christmas Puzzle – The Solution", "url": "https://connor-mcdonald.com/2024/12/26/christmas-puzzle-the-solution/", "published_at": "2024-12-26T04:36:47+00:00" }, { "id": "01a0c537-7526-710f-a6f5-27b5be8ed026", "title": "Kris Kringle the Database – The Christmas MYSTERY", "url": "https://connor-mcdonald.com/2024/12/24/kris-kringle-the-database-the-christmas-mystery/", "published_at": "2024-12-24T10:07:18+00:00" }, { "id": "01a0c537-7526-710f-a6f5-27b5be9dd7e0", "title": "Kris Kringle the Database – All gather ROUND", "url": "https://connor-mcdonald.com/2024/12/23/kris-kringle-the-database-all-gather-round/", "published_at": "2024-12-23T03:31:46+00:00" }, { "id": "01a0c537-7526-710f-a6f5-27b5bed67480", "title": "Kris Kringle the Database – What a Great GROUP", "url": "https://connor-mcdonald.com/2024/12/22/kris-kringle-the-database-what-a-great-group/", "published_at": "2024-12-22T04:50:35+00:00" }, { "id": "01a0c537-7526-710f-a6f5-27b5bf3e971c", "title": "Kris Kringle the Database! What DAY is it?", "url": "https://connor-mcdonald.com/2024/12/21/kris-kringle-the-database-what-day-is-it/", "published_at": "2024-12-21T02:01:10+00:00" }, { "id": "01a0c537-7526-710f-a6f5-27b5bf91efe4", "title": "Kris Kringle the Database – Friday RANT", "url": "https://connor-mcdonald.com/2024/12/20/kris-kringle-the-database-friday-rant/", "published_at": "2024-12-20T05:52:06+00:00" }, { "id": "01a0c537-7526-710f-a6f5-27b5bfda368d", "title": "Kris Kringle the Database – Taking the LEAP", "url": "https://connor-mcdonald.com/2024/12/19/kris-kringle-the-database-taking-the-leap/", "published_at": "2024-12-19T03:24:51+00:00" }, { "id": "01a0c537-7526-710f-a6f5-27b5c0b8a8ee", "title": "Kris Kringle the Database – No Fault in DEFAULT", "url": "https://connor-mcdonald.com/2024/12/18/kris-kringle-the-database-no-fault-in-default/", "published_at": "2024-12-18T04:34:34+00:00" }, { "id": "01a0c537-7526-710f-a6f5-27b5c186d5bf", "title": "Kris Kringle the Database – Know your ABC", "url": "https://connor-mcdonald.com/2024/12/17/kris-kringle-the-database-know-your-abc/", "published_at": "2024-12-16T23:38:01+00:00" }, { "id": "01a0c537-7526-710f-a6f5-27b5c22aba1a", "title": "Kris Kringle the Database – Get the HINT", "url": "https://connor-mcdonald.com/2024/12/16/kris-kringle-the-database-get-the-hint/", "published_at": "2024-12-16T06:03:55+00:00" }, { "id": "01a0c537-7526-710f-a6f5-27b5c26fd6ba", "title": "Kris Kringle the Database – Getting the BAND together", "url": "https://connor-mcdonald.com/2024/12/15/kris-kringle-the-database-getting-the-band-together/", "published_at": "2024-12-15T06:31:55+00:00" }, { "id": "01a0c537-7526-710f-a6f5-27b5c2c5a918", "title": "Kris Kringle the Database – Sequence Values", "url": "https://connor-mcdonald.com/2024/12/14/kris-kringle-the-database-sequence-values/", "published_at": "2024-12-14T02:57:08+00:00" }, { "id": "01a0c537-7526-710f-a6f5-27b5c314c315", "title": "Kris Kringle the Database – Why NVL is smart", "url": "https://connor-mcdonald.com/2024/12/13/kris-kringle-the-database-why-nvl-is-smart/", "published_at": "2024-12-13T04:01:23+00:00" }, { "id": "01a0c537-7526-710f-a6f5-27b5c334fd3a", "title": "Kris Kringle the Database – A Foreign Foreign Key Option", "url": "https://connor-mcdonald.com/2024/12/12/kris-kringle-the-database-a-foreign-foreign-key-option/", "published_at": "2024-12-12T04:40:35+00:00" }, { "id": "01a0c537-7526-710f-a6f5-27b5c361626c", "title": "Kris Kringle the Database – The BEST error", "url": "https://connor-mcdonald.com/2024/12/11/kris-kringle-the-database-the-best-error/", "published_at": "2024-12-11T02:00:40+00:00" }, { "id": "01a0c537-7526-710f-a6f5-27b5c3e1b0a8", "title": "Kris Kringle the Database – The Lazy Date", "url": "https://connor-mcdonald.com/2024/12/10/kris-kringle-the-database-the-lazy-date/", "published_at": "2024-12-10T02:33:48+00:00" }, { "id": "01a0c541-3141-70ed-80a1-f48bbf5685f6", "title": "Kris Kringle the Database – Magic Dates", "url": "https://connor-mcdonald.com/2024/12/09/kris-kringle-the-database-magic-dates/", "published_at": "2024-12-09T06:39:25+00:00" }, { "id": "01a0c541-3141-70ed-80a1-f48bbfaeb79e", "title": "Kris Kringle the Database – GROUP BY out of sorts?", "url": "https://connor-mcdonald.com/2024/12/08/kris-kringle-the-database-group-by-out-of-sorts/", "published_at": "2024-12-08T05:06:48+00:00" }, { "id": "01a0c541-3141-70ed-80a1-f48bc06c30a8", "title": "Kris Kringle the Database – Go higher with hierarchies", "url": "https://connor-mcdonald.com/2024/12/07/kris-kringle-the-database-go-higher-with-hierarchies/", "published_at": "2024-12-07T03:55:20+00:00" }, { "id": "01a0c541-3141-70ed-80a1-f48bc0c0a2da", "title": "Kris Kringle the Database – Index Compression", "url": "https://connor-mcdonald.com/2024/12/06/kris-kringle-the-database-index-compression/", "published_at": "2024-12-06T07:51:56+00:00" }, { "id": "01a0c541-3141-70ed-80a1-f48bc0eda5a5", "title": "Kris Kringle the Database – WIDTH_BUCKET", "url": "https://connor-mcdonald.com/2024/12/05/kris-kringle-the-database-width_bucket/", "published_at": "2024-12-05T08:02:05+00:00" }, { "id": "01a0c541-3141-70ed-80a1-f48bc12311bd", "title": "Kris Kringle the Database! – Truncate and Indexes", "url": "https://connor-mcdonald.com/2024/12/04/kris-kringle-the-database-truncate-and-indexes/", "published_at": "2024-12-04T07:27:44+00:00" }, { "id": "01a0c541-3141-70ed-80a1-f48bc13deba9", "title": "UPDATE SET ROW – Convenience Might Be Costly", "url": "https://connor-mcdonald.com/2024/11/11/update-set-row-convenience-might-be-costly/", "published_at": "2024-11-11T10:59:02+00:00" }, { "id": "01a0c541-3141-70ed-80a1-f48bc1c611fe", "title": "Highlights from the EMEA tour", "url": "https://connor-mcdonald.com/2024/10/28/highlights-from-the-emea-tour/", "published_at": "2024-10-28T12:10:38+00:00" }, { "id": "01a0c541-3141-70ed-80a1-f48bc21c54f2", "title": "SQL*Plus access without an OS login", "url": "https://connor-mcdonald.com/2024/10/16/sqlplus-access-without-an-os-login/", "published_at": "2024-10-16T09:56:08+00:00" }, { "id": "01a0c541-3141-70ed-80a1-f48bc2ddadae", "title": "Better JSON – from CLOB to BLOB", "url": "https://connor-mcdonald.com/2024/10/14/better-json-from-clob-to-blob/", "published_at": "2024-10-14T06:08:12+00:00" }, { "id": "01a0c541-3141-70ed-80a1-f48bc3442c26", "title": "PL/SQL and mistaken IDENTITY", "url": "https://connor-mcdonald.com/2024/10/07/pl-sql-and-mistaken-identity/", "published_at": "2024-10-07T09:56:35+00:00" }, { "id": "01a0c541-3141-70ed-80a1-f48bc43d8462", "title": "Validating Constraints – An alternative approach to the alternative approach!", "url": "https://connor-mcdonald.com/2024/10/02/validating-constraints-an-alternative-approach-to-the-alternative-approach/", "published_at": "2024-10-02T06:47:22+00:00" }, { "id": "01a0c541-3141-70ed-80a1-f48bc4d168d5", "title": "Quick 23ai Tip – Simple list to SQL", "url": "https://connor-mcdonald.com/2024/09/30/quick-23ai-tip-simple-list-to-sql/", "published_at": "2024-09-30T03:22:52+00:00" }, { "id": "01a0c541-3141-70ed-80a1-f48bc58afe32", "title": "How I scraped the CloudWorld catalog", "url": "https://connor-mcdonald.com/2024/09/26/how-i-scraped-the-cloudworld-catalog/", "published_at": "2024-09-26T09:31:58+00:00" }, { "id": "01a0c541-3141-70ed-80a1-f48bc64dc764", "title": "The CloudWorld 2024 mega download!", "url": "https://connor-mcdonald.com/2024/09/20/the-cloudworld-2024-mega-download/", "published_at": "2024-09-20T03:45:01+00:00" }, { "id": "01a0c541-3141-70ed-80a1-f48bc6a6512c", "title": "Oracle Text in 23ai", "url": "https://connor-mcdonald.com/2024/09/18/oracle-text-in-23ai/", "published_at": "2024-09-18T07:35:58+00:00" }, { "id": "01a0c541-3141-70ed-80a1-f48bc73b09eb", "title": "Navigating the Oracle Database documentation", "url": "https://connor-mcdonald.com/2024/09/02/navigating-the-oracle-database-documentation/", "published_at": "2024-09-02T05:55:38+00:00" }, { "id": "01a0c541-3141-70ed-80a1-f48bc7ff1bb2", "title": "SQL … I am so confused", "url": "https://connor-mcdonald.com/2024/09/01/sql-i-am-so-confused/", "published_at": "2024-09-01T13:55:21+00:00" }, { "id": "01a0c541-3141-70ed-80a1-f48bc824d05d", "title": "CloudWorld–Thursday", "url": "https://connor-mcdonald.com/2024/08/29/cloudworld-thursday/", "published_at": "2024-08-29T03:43:19+00:00" }, { "id": "01a0c541-3141-70ed-80a1-f48bc8ca28a2", "title": "CloudWorld Agenda and … APEX!", "url": "https://connor-mcdonald.com/2024/08/26/cloudworld-agenda-and-apex/", "published_at": "2024-08-26T00:42:41+00:00" }, { "id": "01a0c54a-1157-73df-8fdf-9232f1ea5bab", "title": "CloudWorld–Wednesday", "url": "https://connor-mcdonald.com/2024/08/23/cloudworld-wednesday/", "published_at": "2024-08-23T09:26:55+00:00" }, { "id": "01a0c54a-1157-73df-8fdf-9232f23ba29f", "title": "CloudWorld–Tuesday", "url": "https://connor-mcdonald.com/2024/08/21/cloudworld-tuesday/", "published_at": "2024-08-21T04:36:27+00:00" }, { "id": "01a0c54a-1157-73df-8fdf-9232f3208e2b", "title": "CloudWorld–Monday", "url": "https://connor-mcdonald.com/2024/08/19/cloudworld-monday/", "published_at": "2024-08-19T07:06:25+00:00" }, { "id": "01a0c54a-1157-73df-8fdf-9232f3f1128e", "title": "Why I blog – redux", "url": "https://connor-mcdonald.com/2024/08/08/why-i-blog-redux/", "published_at": "2024-08-08T08:59:50+00:00" }, { "id": "01a0c54a-1157-73df-8fdf-9232f44bf24e", "title": "Safeguard your APEX workspaces and applications", "url": "https://connor-mcdonald.com/2024/08/07/safeguard-your-apex-workspaces-and-applications/", "published_at": "2024-08-07T06:43:42+00:00" }, { "id": "01a0c54a-1157-73df-8fdf-9232f479b90f", "title": "23ai – where your vector indexes are stored", "url": "https://connor-mcdonald.com/2024/08/06/23ai-where-your-vector-indexes-are-stored/", "published_at": "2024-08-06T05:04:49+00:00" }, { "id": "01a0c54a-1157-73df-8fdf-9232f4831578", "title": "SQL*Loader rows vanish!", "url": "https://connor-mcdonald.com/2024/08/02/sqlloader-rows-vanish/", "published_at": "2024-08-02T07:47:52+00:00" }, { "id": "01a0c54a-1157-73df-8fdf-9232f4cac495", "title": "Quick Tip – Vector Indexes in 23ai", "url": "https://connor-mcdonald.com/2024/07/03/quick-tip-vector-indexes-in-23ai/", "published_at": "2024-07-03T03:52:31+00:00" }, { "id": "01a0c54a-1157-73df-8fdf-9232f5b083cc", "title": "Got Issues Running an Installer / Assistant on Windows ?", "url": "https://connor-mcdonald.com/2024/06/24/got-issues-running-an-installer-assistant-on-windows/", "published_at": "2024-06-24T12:55:16+00:00" }, { "id": "01a0c54a-1157-73df-8fdf-9232f6973cf6", "title": "Schema level grant in 23ai", "url": "https://connor-mcdonald.com/2024/06/18/schema-level-grant-in-23ai/", "published_at": "2024-06-18T02:38:58+00:00" }, { "id": "01a0c54a-1157-73df-8fdf-9232f7050ba1", "title": "Flashback Query – an important warning", "url": "https://connor-mcdonald.com/2024/06/12/flashback-query-an-important-warning/", "published_at": "2024-06-12T06:42:15+00:00" }, { "id": "01a0c54a-1157-73df-8fdf-9232f7e9341c", "title": "A recommendation for ENUMERATION DOMAINS", "url": "https://connor-mcdonald.com/2024/06/05/a-recommendation-for-enumeration-domains/", "published_at": "2024-06-05T06:58:39+00:00" }, { "id": "01a0c54a-1157-73df-8fdf-9232f84fd32e", "title": "Tracking SQL macro dependencies", "url": "https://connor-mcdonald.com/2024/06/01/tracking-sql-macro-dependencies/", "published_at": "2024-06-01T05:46:46+00:00" }, { "id": "01a0c54a-1157-73df-8fdf-9232f861b012", "title": "Data Centric Apps are better when they do NOT work", "url": "https://connor-mcdonald.com/2024/05/24/data-centric-apps-are-better-when-they-do-not-work/", "published_at": "2024-05-24T03:26:36+00:00" }, { "id": "01a0c54a-1157-73df-8fdf-9232f8a2ffd5", "title": "A SQL conundrum", "url": "https://connor-mcdonald.com/2024/05/20/a-sql-conundrum/", "published_at": "2024-05-20T07:36:29+00:00" }, { "id": "01a0c54a-1157-73df-8fdf-9232f924a7d3", "title": "Backup Paranoia", "url": "https://connor-mcdonald.com/2024/05/12/backup-paranoia/", "published_at": "2024-05-12T13:18:43+00:00" }, { "id": "01a0c54a-1157-73df-8fdf-9232f94da0ec", "title": "The One SQL Thing You Should Never Use", "url": "https://connor-mcdonald.com/2024/05/07/the-one-sql-thing-you-should-never-use/", "published_at": "2024-05-07T03:31:12+00:00" }, { "id": "01a0c54a-1157-73df-8fdf-9232f9b1479d", "title": "23ai – Leave Your Wallet at Home", "url": "https://connor-mcdonald.com/2024/05/04/23ai-leave-your-wallet-at-home/", "published_at": "2024-05-04T03:30:05+00:00" }, { "id": "01a0c54a-1157-73df-8fdf-9232f9bd1701", "title": "Will I lose my existing AUDIT settings in 23ai?", "url": "https://connor-mcdonald.com/2024/04/08/will-i-lose-my-existing-audit-settings-in-23c/", "published_at": "2024-04-08T03:51:38+00:00" }, { "id": "01a0c54a-1157-73df-8fdf-9232f9d76801", "title": "Switching services on Autonomous now easier", "url": "https://connor-mcdonald.com/2024/04/02/switching-services-on-autonomous-now-easier/", "published_at": "2024-04-02T09:57:46+00:00" }, { "id": "01a0c552-8aee-70d5-af78-8eff1cca681a", "title": "I wrote a TERRIBLE app", "url": "https://connor-mcdonald.com/2024/03/25/i-wrote-a-terrible-app/", "published_at": "2024-03-25T10:08:53+00:00" }, { "id": "01a0c552-8aee-70d5-af78-8eff1d899b21", "title": "Bitten by the leap year?", "url": "https://connor-mcdonald.com/2024/03/07/bitten-by-the-leap-year/", "published_at": "2024-03-07T09:52:13+00:00" }, { "id": "01a0c552-8aee-70d5-af78-8eff1dd015d8", "title": "Scalar SQL Macros – cherry pick the best features", "url": "https://connor-mcdonald.com/2024/02/26/scalar-sql-macros-cherry-pick-the-best-features/", "published_at": "2024-02-26T02:44:51+00:00" }, { "id": "01a0c552-8aee-70d5-af78-8eff1de7d9f5", "title": "One Billion Rows – Gerald’s Challenge", "url": "https://connor-mcdonald.com/2024/02/03/one-billion-rows-geralds-challenge/", "published_at": "2024-02-03T11:51:25+00:00" }, { "id": "01a0c552-8aee-70d5-af78-8eff1e952f25", "title": "You can’t partition by time zone, but maybe you can!", "url": "https://connor-mcdonald.com/2024/01/30/you-cant-partition-by-time-zone-but-maybe-you-can/", "published_at": "2024-01-30T11:25:50+00:00" }, { "id": "01a0c552-8aee-70d5-af78-8eff1ef62fb7", "title": "Quick color coding hack for your terminal", "url": "https://connor-mcdonald.com/2024/01/21/quick-color-coding-hack-for-your-terminal/", "published_at": "2024-01-21T11:32:14+00:00" }, { "id": "01a0c552-8aee-70d5-af78-8eff1f09296f", "title": "COUNT(*) versus COUNT(1) – the finale", "url": "https://connor-mcdonald.com/2024/01/12/count-versus-count1-the-finale/", "published_at": "2024-01-12T07:27:51+00:00" }, { "id": "01a0c552-8aee-70d5-af78-8eff1f8a0d3d", "title": "Storm in a TRUNCATE cup", "url": "https://connor-mcdonald.com/2024/01/11/storm-in-a-truncate-cup/", "published_at": "2024-01-11T05:25:00+00:00" }, { "id": "01a0c552-8aee-70d5-af78-8eff1fd12e68", "title": "OT: Working with Camtasia", "url": "https://connor-mcdonald.com/2024/01/10/ot-working-with-camtasia/", "published_at": "2024-01-10T03:23:51+00:00" }, { "id": "01a0c552-8aee-70d5-af78-8eff1fe7fbae", "title": "XMLTYPE on Autonomous", "url": "https://connor-mcdonald.com/2024/01/08/xmltype-on-autonomous/", "published_at": "2024-01-08T04:06:40+00:00" }, { "id": "01a0c552-8aee-70d5-af78-8eff20713b46", "title": "2023 – what a year!", "url": "https://connor-mcdonald.com/2023/12/21/2023-what-a-year/", "published_at": "2023-12-21T05:01:16+00:00" }, { "id": "01a0c552-8aee-70d5-af78-8eff2152e821", "title": "The \"ultimate\" database FREE edition", "url": "https://connor-mcdonald.com/2023/12/18/the-ultimate-database-free-edition/", "published_at": "2023-12-18T08:07:57+00:00" }, { "id": "01a0c552-8aee-70d5-af78-8eff22522b84", "title": "Using AI for test data", "url": "https://connor-mcdonald.com/2023/12/08/using-ai-for-test-data/", "published_at": "2023-12-08T04:01:29+00:00" }, { "id": "01a0c552-8aee-70d5-af78-8eff234aa08e", "title": "JSON and the optimizer", "url": "https://connor-mcdonald.com/2023/12/07/json-and-the-optimizer/", "published_at": "2023-12-07T07:25:10+00:00" }, { "id": "01a0c552-8aee-70d5-af78-8eff23c8acba", "title": "Express Edition needs BIGFILE", "url": "https://connor-mcdonald.com/2023/11/09/express-edition-needs-bigfile/", "published_at": "2023-11-09T13:41:04+00:00" }, { "id": "01a0c552-8aee-70d5-af78-8eff23ce1ed2", "title": "The smaller the database, the more important BIGFILE is", "url": "https://connor-mcdonald.com/2023/10/27/the-smaller-the-database-the-more-important-bigfile-is/", "published_at": "2023-10-27T06:27:11+00:00" }, { "id": "01a0c552-8aee-70d5-af78-8eff2419f283", "title": "Using ROWID for efficient parallel execution", "url": "https://connor-mcdonald.com/2023/10/16/using-rowid-for-efficient-parallel-execution/", "published_at": "2023-10-16T04:59:20+00:00" }, { "id": "01a0c552-8aee-70d5-af78-8eff242df9fd", "title": "New Podcast Episode – The Burden of Proof", "url": "https://connor-mcdonald.com/2023/10/10/new-podcast-episode-the-burden-of-proof/", "published_at": "2023-10-10T07:29:35+00:00" }, { "id": "01a0c552-8aee-70d5-af78-8eff24e27586", "title": "Reset a sequence #JoelKallmanDay", "url": "https://connor-mcdonald.com/2023/10/10/reset-a-sequence-joelkallmanday/", "published_at": "2023-10-09T23:51:03+00:00" }, { "id": "01a0c552-8aee-70d5-af78-8eff2597273d", "title": "SQL Macros will change the world", "url": "https://connor-mcdonald.com/2023/10/04/sql-macros-will-change-the-world/", "published_at": "2023-10-04T06:12:45+00:00" }, { "id": "01a0c55a-ff00-7349-94f0-822e869c8353", "title": "Its back! The CloudWorld MEGA download!", "url": "https://connor-mcdonald.com/2023/09/28/its-back-the-cloudworld-mega-download/", "published_at": "2023-09-27T16:59:23+00:00" }, { "id": "01a0c55a-ff01-736d-8f02-9b6636b58d4a", "title": "Planning for CloudWorld – Lets bring this baby home on Thursday!", "url": "https://connor-mcdonald.com/2023/09/13/planning-for-cloudworld-lets-bring-this-baby-home-on-thursday/", "published_at": "2023-09-13T08:48:18+00:00" }, { "id": "01a0c55a-ff01-736d-8f02-9b6637989532", "title": "Using the 23ai Free Database VM? Check this setting", "url": "https://connor-mcdonald.com/2023/09/11/using-the-23c-free-database-vm-check-this-setting/", "published_at": "2023-09-11T08:18:45+00:00" }, { "id": "01a0c55a-ff01-736d-8f02-9b6637a97bfc", "title": "Planning for CloudWorld … Wednesday is the LAB extravaganza!", "url": "https://connor-mcdonald.com/2023/09/07/planning-for-cloudworld-wednesday-is-the-lab-extravaganza/", "published_at": "2023-09-07T05:36:30+00:00" }, { "id": "01a0c55a-ff01-736d-8f02-9b663839f404", "title": "Planning for CloudWorld … Tuesday is a big day", "url": "https://connor-mcdonald.com/2023/08/29/planning-for-cloudworld-tuesday-is-a-big-day/", "published_at": "2023-08-29T06:51:44+00:00" }, { "id": "01a0c55a-ff01-736d-8f02-9b6639084230", "title": "DBMS_STATS – What is going on?", "url": "https://connor-mcdonald.com/2023/08/15/dbms_stats-what-is-going-on/", "published_at": "2023-08-15T00:57:17+00:00" }, { "id": "01a0c55a-ff01-736d-8f02-9b663947ea18", "title": "TIL a new thing about Private Temporary Tables", "url": "https://connor-mcdonald.com/2023/08/09/til-a-new-thing-about-private-temporary-tables/", "published_at": "2023-08-09T03:55:15+00:00" }, { "id": "01a0c55a-ff01-736d-8f02-9b66398ba5fe", "title": "ChatGPT versus India", "url": "https://connor-mcdonald.com/2023/08/01/chatgpt-versus-india/", "published_at": "2023-08-01T09:32:19+00:00" }, { "id": "01a0c55a-ff01-736d-8f02-9b6639a352c2", "title": "Using Express or Free edition? A potential trap", "url": "https://connor-mcdonald.com/2023/07/17/using-express-or-free-edition-a-potential-trap/", "published_at": "2023-07-17T08:30:44+00:00" }, { "id": "01a0c55a-ff01-736d-8f02-9b6639dcc6ca", "title": "Time Sorted IDs", "url": "https://connor-mcdonald.com/2023/07/11/time-sorted-ids/", "published_at": "2023-07-11T09:48:24+00:00" }, { "id": "01a0c55a-ff01-736d-8f02-9b663aa3fb00", "title": "ORDS upgrade to 23.2. C’mon folks it’s easy!", "url": "https://connor-mcdonald.com/2023/07/06/ords-upgrade-to-23-2-cmon-folks-its-easy/", "published_at": "2023-07-06T12:34:40+00:00" }, { "id": "01a0c55a-ff02-702b-9543-fd3d79d740ae", "title": "What can you find out in 60 seconds?", "url": "https://connor-mcdonald.com/2023/07/04/what-can-you-find-out-in-60-seconds/", "published_at": "2023-07-04T03:05:57+00:00" }, { "id": "01a0c55a-ff02-702b-9543-fd3d79e9c0a4", "title": "Enhancing the EXCHANGE PARTITION command", "url": "https://connor-mcdonald.com/2023/06/19/enhancing-the-exchange-partition-command/", "published_at": "2023-06-19T15:13:51+00:00" }, { "id": "01a0c55a-ff02-702b-9543-fd3d7a002a78", "title": "More Boolean features in 23ai", "url": "https://connor-mcdonald.com/2023/06/09/more-boolean-features-in-23c/", "published_at": "2023-06-09T03:33:44+00:00" }, { "id": "01a0c55a-ff02-702b-9543-fd3d7a577e59", "title": "Dealing with changes to READ ONLY data", "url": "https://connor-mcdonald.com/2023/06/06/dealing-with-changes-to-read-only-data/", "published_at": "2023-06-06T07:37:21+00:00" }, { "id": "01a0c55a-ff02-702b-9543-fd3d7ac1e666", "title": "Why I blog", "url": "https://connor-mcdonald.com/2023/05/29/why-i-blog/", "published_at": "2023-05-29T07:29:04+00:00" }, { "id": "01a0c55a-ff02-702b-9543-fd3d7b28cc63", "title": "Bringing Multimedia back into 19c!", "url": "https://connor-mcdonald.com/2023/05/26/bringing-multimedia-back-into-19c/", "published_at": "2023-05-26T03:26:19+00:00" }, { "id": "01a0c55a-ff02-702b-9543-fd3d7be361e1", "title": "Some \"must-have\" ideas for your next meetup", "url": "https://connor-mcdonald.com/2023/05/24/some-must-have-ideas-for-your-next-meetup/", "published_at": "2023-05-24T02:38:42+00:00" }, { "id": "01a0c55a-ff02-702b-9543-fd3d7c90f071", "title": "Adding APEX 23.1 to your Database Free VM", "url": "https://connor-mcdonald.com/2023/05/22/adding-apex-23-1-to-your-database-free-vm/", "published_at": "2023-05-22T06:32:54+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

2025

JDBC and the FetchSize – Part 2original ↗
28 Jan 2025
JDBC, the FetchSize and staying up to dateoriginal ↗
17 Jan 2025
DataPump – niche fixoriginal ↗
15 Jan 2025
OPatch – The “File In Use” error that wasn’toriginal ↗
7 Jan 2025

2024

The year in numbersoriginal ↗
31 Dec 2024
Christmas Puzzle – The Solutionoriginal ↗
26 Dec 2024
Kris Kringle the Database – The Christmas MYSTERYoriginal ↗
24 Dec 2024
Kris Kringle the Database – All gather ROUNDoriginal ↗
23 Dec 2024
Kris Kringle the Database – What a Great GROUPoriginal ↗
22 Dec 2024
Kris Kringle the Database! What DAY is it?original ↗
21 Dec 2024
Kris Kringle the Database – Friday RANToriginal ↗
20 Dec 2024
Kris Kringle the Database – Taking the LEAPoriginal ↗
19 Dec 2024
Kris Kringle the Database – No Fault in DEFAULToriginal ↗
18 Dec 2024
Kris Kringle the Database – Know your ABCoriginal ↗
16 Dec 2024
Kris Kringle the Database – Get the HINToriginal ↗
16 Dec 2024
Kris Kringle the Database – Getting the BAND togetheroriginal ↗
15 Dec 2024
Kris Kringle the Database – Sequence Valuesoriginal ↗
14 Dec 2024
Kris Kringle the Database – Why NVL is smartoriginal ↗
13 Dec 2024
Kris Kringle the Database – A Foreign Foreign Key Optionoriginal ↗
12 Dec 2024
Kris Kringle the Database – The BEST errororiginal ↗
11 Dec 2024
Kris Kringle the Database – The Lazy Dateoriginal ↗
10 Dec 2024
Kris Kringle the Database – Magic Datesoriginal ↗
9 Dec 2024
Kris Kringle the Database – GROUP BY out of sorts?original ↗
8 Dec 2024
Kris Kringle the Database – Go higher with hierarchiesoriginal ↗
7 Dec 2024
Kris Kringle the Database – Index Compressionoriginal ↗
6 Dec 2024
Kris Kringle the Database – WIDTH_BUCKEToriginal ↗
5 Dec 2024
Kris Kringle the Database! – Truncate and Indexesoriginal ↗
4 Dec 2024
UPDATE SET ROW – Convenience Might Be Costlyoriginal ↗
11 Nov 2024
Highlights from the EMEA touroriginal ↗
28 Oct 2024
SQL*Plus access without an OS loginoriginal ↗
16 Oct 2024
Better JSON – from CLOB to BLOBoriginal ↗
14 Oct 2024
PL/SQL and mistaken IDENTITYoriginal ↗
7 Oct 2024
Validating Constraints – An alternative approach to the alternative approach!original ↗
2 Oct 2024
Quick 23ai Tip – Simple list to SQLoriginal ↗
30 Sept 2024
How I scraped the CloudWorld catalogoriginal ↗
26 Sept 2024
The CloudWorld 2024 mega download!original ↗
20 Sept 2024
Oracle Text in 23aioriginal ↗
18 Sept 2024
Navigating the Oracle Database documentationoriginal ↗
2 Sept 2024
SQL … I am so confusedoriginal ↗
1 Sept 2024
CloudWorld–Thursdayoriginal ↗
29 Aug 2024
CloudWorld Agenda and … APEX!original ↗
26 Aug 2024
CloudWorld–Wednesdayoriginal ↗
23 Aug 2024
CloudWorld–Tuesdayoriginal ↗
21 Aug 2024
CloudWorld–Mondayoriginal ↗
19 Aug 2024
Why I blog – reduxoriginal ↗
8 Aug 2024
Safeguard your APEX workspaces and applicationsoriginal ↗
7 Aug 2024
23ai – where your vector indexes are storedoriginal ↗
6 Aug 2024
SQL*Loader rows vanish!original ↗
2 Aug 2024
Quick Tip – Vector Indexes in 23aioriginal ↗
3 Jul 2024
Got Issues Running an Installer / Assistant on Windows ?original ↗
24 Jun 2024
Schema level grant in 23aioriginal ↗
18 Jun 2024
Flashback Query – an important warningoriginal ↗
12 Jun 2024
A recommendation for ENUMERATION DOMAINSoriginal ↗
5 Jun 2024
Tracking SQL macro dependenciesoriginal ↗
1 Jun 2024
Data Centric Apps are better when they do NOT workoriginal ↗
24 May 2024
A SQL conundrumoriginal ↗
20 May 2024
Backup Paranoiaoriginal ↗
12 May 2024
The One SQL Thing You Should Never Useoriginal ↗
7 May 2024
23ai – Leave Your Wallet at Homeoriginal ↗
4 May 2024
Will I lose my existing AUDIT settings in 23ai?original ↗
8 Apr 2024
Switching services on Autonomous now easieroriginal ↗
2 Apr 2024
I wrote a TERRIBLE apporiginal ↗
25 Mar 2024
Bitten by the leap year?original ↗
7 Mar 2024
Scalar SQL Macros – cherry pick the best featuresoriginal ↗
26 Feb 2024
One Billion Rows – Gerald’s Challengeoriginal ↗
3 Feb 2024
You can’t partition by time zone, but maybe you can!original ↗
30 Jan 2024
Quick color coding hack for your terminaloriginal ↗
21 Jan 2024
COUNT(*) versus COUNT(1) – the finaleoriginal ↗
12 Jan 2024
Storm in a TRUNCATE cuporiginal ↗
11 Jan 2024
OT: Working with Camtasiaoriginal ↗
10 Jan 2024
XMLTYPE on Autonomousoriginal ↗
8 Jan 2024

2023

2023 – what a year!original ↗
21 Dec 2023
The "ultimate" database FREE editionoriginal ↗
18 Dec 2023
Using AI for test dataoriginal ↗
8 Dec 2023
JSON and the optimizeroriginal ↗
7 Dec 2023
Express Edition needs BIGFILEoriginal ↗
9 Nov 2023
The smaller the database, the more important BIGFILE isoriginal ↗
27 Oct 2023
Using ROWID for efficient parallel executionoriginal ↗
16 Oct 2023
New Podcast Episode – The Burden of Prooforiginal ↗
10 Oct 2023
Reset a sequence #JoelKallmanDayoriginal ↗
9 Oct 2023
SQL Macros will change the worldoriginal ↗
4 Oct 2023
Its back! The CloudWorld MEGA download!original ↗
27 Sept 2023
Planning for CloudWorld – Lets bring this baby home on Thursday!original ↗
13 Sept 2023
Using the 23ai Free Database VM? Check this settingoriginal ↗
11 Sept 2023
Planning for CloudWorld … Wednesday is the LAB extravaganza!original ↗
7 Sept 2023
Planning for CloudWorld … Tuesday is a big dayoriginal ↗
29 Aug 2023
DBMS_STATS – What is going on?original ↗
15 Aug 2023
TIL a new thing about Private Temporary Tablesoriginal ↗
9 Aug 2023
ChatGPT versus Indiaoriginal ↗
1 Aug 2023
Using Express or Free edition? A potential traporiginal ↗
17 Jul 2023
Time Sorted IDsoriginal ↗
11 Jul 2023
ORDS upgrade to 23.2. C’mon folks it’s easy!original ↗
6 Jul 2023
What can you find out in 60 seconds?original ↗
4 Jul 2023
Enhancing the EXCHANGE PARTITION commandoriginal ↗
19 Jun 2023
More Boolean features in 23aioriginal ↗
9 Jun 2023
Dealing with changes to READ ONLY dataoriginal ↗
6 Jun 2023
Why I blogoriginal ↗
29 May 2023
Bringing Multimedia back into 19c!original ↗
26 May 2023
Some "must-have" ideas for your next meetuporiginal ↗
24 May 2023
Adding APEX 23.1 to your Database Free VMoriginal ↗
22 May 2023
Previous Next