41554 blogs · [ { "id": "01a087dd-77cf-7357-aef6-af88fa7fecf5", "title": "CMU bug fixed in July DBRU for 19c and 26ai", "url": "https://seanstuber.com/2026/08/22/cmu-bug-fixed-in-july-dbru-for-19c-and-26ai/", "published_at": "2026-08-23T00:00:28+00:00" }, { "id": "01a087dd-77cf-7357-aef6-af88faea6fe9", "title": "See you at KScope!", "url": "https://seanstuber.com/2026/06/15/see-you-at-kscope/", "published_at": "2026-06-15T04:21:57+00:00" }, { "id": "01a087dd-77cf-7357-aef6-af88fb1c6c82", "title": "Solving Performance Problems with a Touch of Magic", "url": "https://seanstuber.com/2026/05/03/solving-performance-problems-with-a-touch-of-magic/", "published_at": "2026-05-04T01:14:57+00:00" }, { "id": "01a087dd-77cf-7357-aef6-af88fbf75d39", "title": "Assertions in 26ai", "url": "https://seanstuber.com/2026/03/15/assertions-in-26ai/", "published_at": "2026-03-16T02:16:22+00:00" }, { "id": "01a087dd-77cf-7357-aef6-af88fc34bf1e", "title": "Advent of Code 2025- Day 11", "url": "https://seanstuber.com/2026/01/11/advent-of-code-2025-day-11/", "published_at": "2026-01-11T21:59:20+00:00" }, { "id": "01a087dd-77cf-7357-aef6-af88fcb7db58", "title": "Advent of Code 2025- Day 9", "url": "https://seanstuber.com/2026/01/02/advent-of-code-2025-day-9/", "published_at": "2026-01-02T14:54:38+00:00" }, { "id": "01a087dd-77cf-7357-aef6-af88fccd44cd", "title": "Advent of Code 2025- Day 8", "url": "https://seanstuber.com/2025/12/24/advent-of-code-2025-day-8/", "published_at": "2025-12-24T07:16:46+00:00" }, { "id": "01a087dd-77cf-7357-aef6-af88fcf8903f", "title": "Advent of Code 2025- Day 7", "url": "https://seanstuber.com/2025/12/16/advent-of-code-2025-day-7/", "published_at": "2025-12-17T04:55:04+00:00" }, { "id": "01a087dd-77cf-7357-aef6-af88fdd0d658", "title": "Advent of Code 2025- Day 6", "url": "https://seanstuber.com/2025/12/13/advent-of-code-2025-day-6/", "published_at": "2025-12-14T03:27:13+00:00" }, { "id": "01a087dd-77cf-7357-aef6-af88fdd9110e", "title": "Advent of Code 2025- Day 5", "url": "https://seanstuber.com/2025/12/10/advent-of-code-day-5/", "published_at": "2025-12-10T05:18:27+00:00" }, { "id": "01a0ca4f-fd38-7271-b267-dca8afddea99", "title": "Advent of Code 2025 – Day 4", "url": "https://seanstuber.com/2025/12/09/advent-of-code-2025-day-4/", "published_at": "2025-12-09T23:00:31+00:00" }, { "id": "01a0ca4f-fd38-7271-b267-dca8b05aa7f9", "title": "Advent of Code 2025 – Day 3", "url": "https://seanstuber.com/2025/12/06/advent-of-code-2025-day-3/", "published_at": "2025-12-06T05:41:04+00:00" }, { "id": "01a0ca4f-fd38-7271-b267-dca8b0a81b94", "title": "Advent of Code 2025 – Day 2", "url": "https://seanstuber.com/2025/12/05/advent-of-code-2025-day-2/", "published_at": "2025-12-05T21:38:00+00:00" }, { "id": "01a0ca4f-fd38-7271-b267-dca8b11c7e11", "title": "26ai coming to on-prem in January!", "url": "https://seanstuber.com/2025/12/05/26ai-coming-to-on-prem-in-january/", "published_at": "2025-12-05T12:31:36+00:00" }, { "id": "01a0ca4f-fd38-7271-b267-dca8b174f068", "title": "Advent of Code 2025 – Day 1", "url": "https://seanstuber.com/2025/12/05/advent-of-code-2025-day-1/", "published_at": "2025-12-05T07:13:22+00:00" }, { "id": "01a0ca4f-fd38-7271-b267-dca8b2016d3d", "title": "Creating APEX report with rolling set of columns #JoelKallmanDay", "url": "https://seanstuber.com/2025/10/15/creating-apex-report-with-rolling-set-of-columns-joelkallmanday/", "published_at": "2025-10-15T04:00:00+00:00" }, { "id": "01a0ca4f-fd38-7271-b267-dca8b25330ec", "title": "Duplicating an IG does not duplicate Automatic Row Processing DML", "url": "https://seanstuber.com/2025/10/14/duplicating-an-ig-does-not-duplicate-automatic-row-processing-dml/", "published_at": "2025-10-14T05:46:04+00:00" }, { "id": "01a0ca4f-fd38-7271-b267-dca8b2eb9b0a", "title": "Using SQL to derive dice distributions in D&D", "url": "https://seanstuber.com/2025/07/29/using-sql-to-derive-dice-distributions-in-dnd/", "published_at": "2025-07-29T06:06:30+00:00" }, { "id": "01a0ca4f-fd38-7271-b267-dca8b3c5c0e6", "title": "Bringing APEX and PL/SQL to D&D", "url": "https://seanstuber.com/2025/07/19/bringing-apex-and-pl-sql-to-dd/", "published_at": "2025-07-20T00:09:20+00:00" }, { "id": "01a0ca4f-fd38-7271-b267-dca8b3fd5d7d", "title": "Interesting bug with nondeterministic functions", "url": "https://seanstuber.com/2025/05/14/interesting-bug-with-nondeterministic-functions/", "published_at": "2025-05-14T04:48:21+00:00" }, { "id": "01a0ca50-2d2b-72e8-8161-942da27a76c3", "title": "New Certification and FeedSpot Recognition", "url": "https://seanstuber.com/2025/04/13/new-certification-and-feedspot-recognition/", "published_at": "2025-04-14T03:45:16+00:00" }, { "id": "01a0ca50-2d2b-72e8-8161-942da30a7c90", "title": "PL/SQL package for 32-bit xoshiro/xoroshiro pseudorandom number generators", "url": "https://seanstuber.com/2025/03/15/pl-sql-package-for-32-bit-xoshiro-xoroshiro-pseudorandom-number-generators/", "published_at": "2025-03-15T23:36:50+00:00" }, { "id": "01a0ca50-2d2b-72e8-8161-942da388dcf1", "title": "PL/SQL package for 64-bit xoshiro/xoroshiro pseudorandom number generators", "url": "https://seanstuber.com/2025/03/01/pl-sql-package-for-64-bit-xoshiro-xoroshiro-pseudo-random-number-generators/", "published_at": "2025-03-02T00:50:44+00:00" }, { "id": "01a0ca50-2d2b-72e8-8161-942da3f32cf4", "title": "Bit manipulation of large numbers in pl/sql", "url": "https://seanstuber.com/2025/02/16/bit-manipulation-of-large-numbers-in-pl-sql/", "published_at": "2025-02-17T00:46:28+00:00" }, { "id": "01a0ca50-2d2b-72e8-8161-942da49c2c3d", "title": "Implementing xoshiro256** in PL/SQL", "url": "https://seanstuber.com/2025/02/14/implementing-xoshiro256-in-pl-sql/", "published_at": "2025-02-14T22:31:37+00:00" }, { "id": "01a0ca50-2d2b-72e8-8161-942da4c5785e", "title": "Advent of Code 2024 – Day 4", "url": "https://seanstuber.com/2025/01/25/advent-of-code-2024-day-4/", "published_at": "2025-01-25T23:00:27+00:00" }, { "id": "01a0ca50-2d2b-72e8-8161-942da5084cde", "title": "Advent of Code 2024 – Day 3", "url": "https://seanstuber.com/2025/01/25/advent-of-code-2024-day-3/", "published_at": "2025-01-25T22:22:16+00:00" }, { "id": "01a0ca50-2d2b-72e8-8161-942da5d1628e", "title": "Advent of Code 2024 – Day 2", "url": "https://seanstuber.com/2025/01/25/advent-of-code-2024-day-2/", "published_at": "2025-01-25T21:57:43+00:00" }, { "id": "01a0ca50-2d2b-72e8-8161-942da615ce00", "title": "Advent of Code 2024 – Day 1", "url": "https://seanstuber.com/2025/01/16/advent-of-code-2024-day-1/", "published_at": "2025-01-17T02:17:02+00:00" }, { "id": "01a0ca50-2d2b-72e8-8161-942da6d570a0", "title": "Exploring the PAIRS OF iterator", "url": "https://seanstuber.com/2024/11/05/exploring-the-pairs-of-iterator/", "published_at": "2024-11-05T07:21:17+00:00" }, { "id": "01a0ca50-5ce5-71f0-acba-16c26c6f3862", "title": "How To Implement Glicko-2 In PL/SQL #JoelKallmanDay", "url": "https://seanstuber.com/2024/10/16/how-to-implement-glicko-2-in-pl-sql-joelkallmanday/", "published_at": "2024-10-16T04:00:00+00:00" }, { "id": "01a0ca50-5ce5-71f0-acba-16c26d2e87c8", "title": "23ai PL/SQL Dangling Predicates in CASE expressions", "url": "https://seanstuber.com/2024/08/26/23ai-pl-sql-dangling-predicates-in-case-expressions/", "published_at": "2024-08-26T04:01:18+00:00" }, { "id": "01a0ca50-5ce5-71f0-acba-16c26dc4600d", "title": "Choosing OpenAI model with Oracle 23ai SELECT", "url": "https://seanstuber.com/2024/07/20/choosing-openai-model-with-oracle-23ai-select/", "published_at": "2024-07-20T22:34:23+00:00" }, { "id": "01a0ca50-5ce5-71f0-acba-16c26e2ca342", "title": "Using MLE JavaScript function to iterate JSON Keys in SQL", "url": "https://seanstuber.com/2024/05/02/using-mle-javascript-function-to-iterate-json-keys-in-sql/", "published_at": "2024-05-02T04:21:11+00:00" }, { "id": "01a0ca50-5ce5-71f0-acba-16c26ecbac10", "title": "Using a Java function to iterate large JSON with many keys.", "url": "https://seanstuber.com/2024/03/05/using-a-java-function-to-iterate-large-json-with-many-keys/", "published_at": "2024-03-06T03:54:57+00:00" }, { "id": "01a0ca50-5ce5-71f0-acba-16c26f339478", "title": "How to create a PL/SQL function to iterate JSON Keys for SQL", "url": "https://seanstuber.com/2024/03/02/how-to-create-a-pl-sql-function-to-iterate-json-keys-for-sql/", "published_at": "2024-03-03T00:02:50+00:00" }, { "id": "01a0ca50-5ce5-71f0-acba-16c26f3ac0c3", "title": "How to use and view comments to your parameter changes", "url": "https://seanstuber.com/2023/12/29/how-to-use-and-view-comments-to-your-parameter-changes/", "published_at": "2023-12-29T22:45:25+00:00" }, { "id": "01a0ca50-5ce5-71f0-acba-16c270043bcd", "title": "Comparing 19c vs 21c JSON key lists", "url": "https://seanstuber.com/2023/12/04/comparing-19c-vs-21c-json-key-lists/", "published_at": "2023-12-05T03:29:53+00:00" }, { "id": "01a0ca50-5ce5-71f0-acba-16c2700b9925", "title": "How to recursively search JSON with PL/SQL", "url": "https://seanstuber.com/2023/12/03/how-to-recursively-search-json-with-pl-sql/", "published_at": "2023-12-04T04:38:44+00:00" }, { "id": "01a0ca50-5ce5-71f0-acba-16c27051bc35", "title": "Calculating Skewness of a Population", "url": "https://seanstuber.com/2023/10/12/calculating-skewness-of-a-population/", "published_at": "2023-10-12T04:40:32+00:00" }, { "id": "01a0ca50-9599-7135-bbd3-64bff59213f0", "title": "Calculating Skewness of a Sample #JoelKallmanDay", "url": "https://seanstuber.com/2023/10/11/calculating-skewness-of-a-sample/", "published_at": "2023-10-11T04:01:00+00:00" }, { "id": "01a0ca50-9599-7135-bbd3-64bff66657a2", "title": "23ai adds PING to SQL*Plus", "url": "https://seanstuber.com/2023/09/29/23c-adds-ping-to-sqlplus/", "published_at": "2023-09-29T04:07:16+00:00" }, { "id": "01a0ca50-9599-7135-bbd3-64bff737f681", "title": "Pipelined PL/SQL and Java with ODCI", "url": "https://seanstuber.com/2023/07/16/pipelined-pl-sql-and-java-with-odci/", "published_at": "2023-07-16T06:16:25+00:00" }, { "id": "01a0ca50-9599-7135-bbd3-64bff7717803", "title": "Working with Table Functions in SQL", "url": "https://seanstuber.com/2023/07/08/working-with-table-functions-in-sql/", "published_at": "2023-07-08T18:15:35+00:00" }, { "id": "01a0ca50-9599-7135-bbd3-64bff7cb379a", "title": "Exiting the OJVM in your db session", "url": "https://seanstuber.com/2023/07/01/exiting-the-ojvm-in-your-db-session/", "published_at": "2023-07-01T23:36:45+00:00" }, { "id": "01a0ca50-9599-7135-bbd3-64bff8c2553b", "title": "Oracle 23ai interval aggregates", "url": "https://seanstuber.com/2023/05/08/oracle-23c-interval-aggregates/", "published_at": "2023-05-09T03:25:31+00:00" }, { "id": "01a0ca50-9599-7135-bbd3-64bff932cb7b", "title": "Oracle 23ai Boolean support in SQL", "url": "https://seanstuber.com/2023/04/22/oracle-23c-boolean-support-in-sql/", "published_at": "2023-04-22T20:59:52+00:00" }, { "id": "01a0ca50-9599-7135-bbd3-64bff94a5dd1", "title": "Date/Timestamp Cheat Sheet", "url": "https://seanstuber.com/2023/03/30/date-timestamp-cheat-sheet/", "published_at": "2023-03-30T23:50:48+00:00" }, { "id": "01a0ca50-9599-7135-bbd3-64bff9ce50b0", "title": "Finding dates of holidays using PL/SQL", "url": "https://seanstuber.com/2023/03/19/finding-dates-of-holidays-using-pl-sql/", "published_at": "2023-03-19T04:41:16+00:00" }, { "id": "01a0ca50-9599-7135-bbd3-64bffa027e52", "title": "Calculating Binomial Distribution Probabilities in PL/SQL", "url": "https://seanstuber.com/2023/03/18/calculating-binomial-distribution-probabilities-in-pl-sql/", "published_at": "2023-03-18T20:35:15+00:00" }, { "id": "01a0ca50-cb02-7036-b528-1aeb4560a5a6", "title": "Large Number Combinatoric calculations in PL/SQL", "url": "https://seanstuber.com/2023/02/11/large-number-combinatoric-calculations-in-pl-sql/", "published_at": "2023-02-11T15:05:46+00:00" }, { "id": "01a0ca50-cb02-7036-b528-1aeb45e4b049", "title": "Let NULL work for you #JoelKallmanDay", "url": "https://seanstuber.com/2022/10/11/let-null-work-for-you-joelkallmanday/", "published_at": "2022-10-11T04:57:07+00:00" }, { "id": "01a0ca50-cb02-7036-b528-1aeb46395e30", "title": "Mean, Median, and Mode of summarized data", "url": "https://seanstuber.com/2022/09/23/mean-median-and-mode-of-summarized-data/", "published_at": "2022-09-23T04:46:50+00:00" }, { "id": "01a0ca50-cb02-7036-b528-1aeb46555915", "title": "Calculating Hypergeometric Distribution probability in PL/SQL", "url": "https://seanstuber.com/2022/08/26/calculating-hypergeometric-distribution-probability-in-pl-sql/", "published_at": "2022-08-26T05:05:07+00:00" }, { "id": "01a0ca50-cb02-7036-b528-1aeb466c9468", "title": "Working with Collections in SQL", "url": "https://seanstuber.com/2022/04/30/working-with-collections-in-sql/", "published_at": "2022-04-30T06:47:51+00:00" }, { "id": "01a0ca50-cb02-7036-b528-1aeb46bced8c", "title": "SQL and Set Theory", "url": "https://seanstuber.com/2022/04/22/sql-and-set-theory/", "published_at": "2022-04-22T05:26:58+00:00" }, { "id": "01a0ca50-cb02-7036-b528-1aeb476872a9", "title": "Sending Email with Oracle, Part 10: Pulling it all together", "url": "https://seanstuber.com/2022/04/14/sending-email-with-oracle-part-10-pulling-it-all-together/", "published_at": "2022-04-14T06:32:34+00:00" }, { "id": "01a0ca50-cb02-7036-b528-1aeb47ca2291", "title": "Sending Email with Oracle, Part 9: Alternative content", "url": "https://seanstuber.com/2022/04/14/sending-email-with-oracle-part-9-alternative-content/", "published_at": "2022-04-14T06:32:19+00:00" }, { "id": "01a0ca50-cb02-7036-b528-1aeb4829e0c6", "title": "Sending Email with Oracle, Part 8: HTML-formatted content", "url": "https://seanstuber.com/2022/04/14/sending-email-with-oracle-part-8-html-formatted-content/", "published_at": "2022-04-14T06:31:50+00:00" }, { "id": "01a0ca50-cb02-7036-b528-1aeb49028dab", "title": "Sending Email with Oracle, Part 6: MIME Content", "url": "https://seanstuber.com/2022/04/14/sending-email-with-oracle-part-6-mime-content/", "published_at": "2022-04-14T06:31:21+00:00" }, { "id": "01a0ca51-1260-71be-8170-87a16b9e462d", "title": "Sending Email with Oracle, Part 7: UTL_SMTP – Attachments", "url": "https://seanstuber.com/2022/03/17/sending-email-with-oracle-part-7-utl_smtp-attachments/", "published_at": "2022-03-17T23:40:26+00:00" }, { "id": "01a0ca51-1260-71be-8170-87a16bb917bf", "title": "Free Falling with PL/SQL", "url": "https://seanstuber.com/2022/02/24/free-falling-with-pl-sql/", "published_at": "2022-02-25T04:54:57+00:00" }, { "id": "01a0ca51-1260-71be-8170-87a16c1e5c25", "title": "Sending Email with Oracle, Part 5: UTL_SMTP – Authentication (manual)", "url": "https://seanstuber.com/2021/12/30/sending-email-with-oracle-part-5-utl_smtp-authentication-manual/", "published_at": "2021-12-30T05:00:59+00:00" }, { "id": "01a0ca51-1260-71be-8170-87a16cf65a57", "title": "Sending Email with Oracle, Part 3: UTL_SMTP – Introduction", "url": "https://seanstuber.com/2021/12/30/sending-email-with-oracle-part-3-utl_smtp-introduction/", "published_at": "2021-12-30T05:00:52+00:00" }, { "id": "01a0ca51-1260-71be-8170-87a16d9e5a87", "title": "Sending Email with Oracle, Part 2: APEX_MAIL", "url": "https://seanstuber.com/2021/12/30/sending-email-with-oracle-part-2-apex_mail/", "published_at": "2021-12-30T05:00:37+00:00" }, { "id": "01a0ca51-1260-71be-8170-87a16e710259", "title": "Sending Email with Oracle, Part 4: UTL_SMTP – Authentication (API)", "url": "https://seanstuber.com/2021/12/30/sending-email-with-oracle-part-4-utl_smtp-authentication-api/", "published_at": "2021-12-30T05:00:33+00:00" }, { "id": "01a0ca51-1260-71be-8170-87a16f2b36a0", "title": "Sending Email with Oracle, Part 1: UTL_MAIL", "url": "https://seanstuber.com/2021/12/30/sending-email-with-oracle-part-1-utl_mail/", "published_at": "2021-12-30T05:00:18+00:00" }, { "id": "01a0ca51-1260-71be-8170-87a16fdf76d7", "title": "SQL vs Towers of Hanoi", "url": "https://seanstuber.com/2021/11/29/sql-vs-towers-of-hanoi/", "published_at": "2021-11-30T04:16:44+00:00" }, { "id": "01a0ca51-1260-71be-8170-87a170adcdc3", "title": "LDAP to JSON function #JoelKallmanDay", "url": "https://seanstuber.com/2021/10/11/ldap-to-json-function-joelkallmanday/", "published_at": "2021-10-11T04:01:54+00:00" }, { "id": "01a0ca51-1260-71be-8170-87a170fc2326", "title": "Solving the Water Jug puzzle with SQL", "url": "https://seanstuber.com/2021/10/08/solving-the-water-jug-puzzle-with-sql/", "published_at": "2021-10-08T04:29:39+00:00" }, { "id": "01a0ca51-49f0-71cf-a942-737ba21840de", "title": "Recursive WITH clause join bug", "url": "https://seanstuber.com/2021/10/07/recursive-with-clause-join-bug/", "published_at": "2021-10-07T21:39:39+00:00" }, { "id": "01a0ca51-49f0-71cf-a942-737ba2f48ca6", "title": "SQL meets Calculus", "url": "https://seanstuber.com/2021/10/01/sql-meets-calculus/", "published_at": "2021-10-01T07:11:11+00:00" }, { "id": "01a0ca51-49f0-71cf-a942-737ba397322b", "title": "21c My easiest upgrade ever", "url": "https://seanstuber.com/2021/08/22/21c-my-easiest-upgrade-ever/", "published_at": "2021-08-22T17:22:53+00:00" }, { "id": "01a0ca51-49f0-71cf-a942-737ba3e62212", "title": "In memory of Joel Kallman", "url": "https://seanstuber.com/2021/05/28/in-memory-of-joel-kallman/", "published_at": "2021-05-28T20:41:19+00:00" }, { "id": "01a0ca51-49f0-71cf-a942-737ba3f83599", "title": "ORA_COMPLEXITY_CHECK quirks and alternative", "url": "https://seanstuber.com/2021/04/20/ora_complexity_check-quirks-and-alternative/", "published_at": "2021-04-20T04:01:48+00:00" }, { "id": "01a0ca51-49f0-71cf-a942-737ba40d0059", "title": "Solving the Four Weights combination puzzle with SQL", "url": "https://seanstuber.com/2021/03/21/solving-the-four-weights-combination-puzzle-with-sql/", "published_at": "2021-03-22T02:36:29+00:00" }, { "id": "01a0ca51-49f0-71cf-a942-737ba45b8775", "title": "Dynamic Action Link with APEX chart", "url": "https://seanstuber.com/2021/03/21/dynamic-action-link-with-apex-chart/", "published_at": "2021-03-21T10:14:45+00:00" }, { "id": "01a0ca51-49f0-71cf-a942-737ba55631d3", "title": "How to TNSPING without TNSPING", "url": "https://seanstuber.com/2021/03/18/how-to-tnsping-without-tnsping/", "published_at": "2021-03-18T04:06:15+00:00" }, { "id": "01a0ca51-49f0-71cf-a942-737ba62a6008", "title": "Creating DB Links between two Oracle Autonomous databases", "url": "https://seanstuber.com/2021/03/13/creating-db-links-between-two-oracle-autonomous-databases/", "published_at": "2021-03-14T01:11:12+00:00" }, { "id": "01a0ca51-49f0-71cf-a942-737ba6b0e7c0", "title": "Creating DB Link to Oracle Cloud ADB from an on-premises database", "url": "https://seanstuber.com/2021/03/06/creating-db-link-to-oracle-cloud-adb-from-an-on-premises-database/", "published_at": "2021-03-06T23:28:15+00:00" }, { "id": "01a0ca51-6f7d-7096-862b-a3ad1f4d7542", "title": "PUBLIC privileges: reading the DB Version", "url": "https://seanstuber.com/2021/02/26/public-privileges-reading-the-db-version/", "published_at": "2021-02-26T05:35:36+00:00" }, { "id": "01a0ca51-6f7d-7096-862b-a3ad1f516e26", "title": "LDAP – TNS service name package v2.3", "url": "https://seanstuber.com/2021/02/20/ldap-tns-service-name-package-v2-3/", "published_at": "2021-02-20T06:07:06+00:00" }, { "id": "01a0ca51-6f7d-7096-862b-a3ad1f5d391f", "title": "How to put an “IF” inside SQL", "url": "https://seanstuber.com/2021/02/19/how-to-put-an-if-inside-sql/", "published_at": "2021-02-19T06:56:00+00:00" }, { "id": "01a0ca51-6f7d-7096-862b-a3ad1fa6cbf8", "title": "If You Shoot Yourself in the Foot… Don’t Reload", "url": "https://seanstuber.com/2021/02/11/if-you-shoot-yourself-in-the-foot-dont-reload/", "published_at": "2021-02-11T06:08:49+00:00" }, { "id": "01a0ca51-6f7d-7096-862b-a3ad1faf09ed", "title": "Dates and Timestamps – the TRUNC function", "url": "https://seanstuber.com/2021/01/30/dates-and-timestamps-the-trunc-function/", "published_at": "2021-01-31T02:48:03+00:00" }, { "id": "01a0ca51-6f7d-7096-862b-a3ad20a5c0f6", "title": "The 12-Coins Puzzle in PL/SQL", "url": "https://seanstuber.com/2021/01/17/the-12-coins-puzzle-in-pl-sql/", "published_at": "2021-01-17T07:14:03+00:00" }, { "id": "01a0ca51-6f7d-7096-862b-a3ad20bdbec6", "title": "The 8-Queens Puzzle in PL/SQL", "url": "https://seanstuber.com/2021/01/13/the-8-queens-puzzle-in-pl-sql/", "published_at": "2021-01-13T06:55:59+00:00" }, { "id": "01a0ca51-6f7d-7096-862b-a3ad216d2132", "title": "Counting Query Combinatorics", "url": "https://seanstuber.com/2021/01/09/counting-query-combinatorics/", "published_at": "2021-01-09T07:33:25+00:00" }, { "id": "01a0ca51-6f7d-7096-862b-a3ad217c020e", "title": "Oracle Intervals – Year to Month", "url": "https://seanstuber.com/2020/12/30/oracle-intervals-year-to-month/", "published_at": "2020-12-30T19:52:27+00:00" }, { "id": "01a0ca51-6f7d-7096-862b-a3ad21a54271", "title": "Oracle Intervals – Day to Second", "url": "https://seanstuber.com/2020/12/23/oracle-intervals-day-to-second/", "published_at": "2020-12-23T22:23:11+00:00" }, { "id": "01a0ca51-9e8b-7206-83f8-7d0cb1016034", "title": "Oracle Intervals – Overview", "url": "https://seanstuber.com/2020/12/23/oracle-intervals-overview/", "published_at": "2020-12-23T13:49:31+00:00" }, { "id": "01a0ca51-9e8b-7206-83f8-7d0cb119b1c5", "title": "Time Zones, Daylight Saving Time, and Data Types", "url": "https://seanstuber.com/2020/11/19/time-zones-daylight-saving-time-and-data-types/", "published_at": "2020-11-19T06:28:16+00:00" }, { "id": "01a0ca51-9e8b-7206-83f8-7d0cb1387ebe", "title": "Connection Basics", "url": "https://seanstuber.com/2020/06/08/connection-basics/", "published_at": "2020-06-08T04:15:11+00:00" }, { "id": "01a0ca51-9e8b-7206-83f8-7d0cb2303482", "title": "Date and Timestamp Formats and Structure", "url": "https://seanstuber.com/2020/05/17/dates-and-timestamp-formats-and-structure/", "published_at": "2020-05-17T06:11:35+00:00" }, { "id": "01a0ca51-9e8b-7206-83f8-7d0cb29442ec", "title": "Data type quirks in Oracle", "url": "https://seanstuber.com/2020/04/08/data-type-quirks-in-oracle/", "published_at": "2020-04-08T05:01:30+00:00" }, { "id": "01a0ca51-9e8b-7206-83f8-7d0cb2f15d87", "title": "Using Correct Data Types", "url": "https://seanstuber.com/2020/04/05/using-correct-data-types/", "published_at": "2020-04-05T15:05:00+00:00" }, { "id": "01a0ca51-9e8b-7206-83f8-7d0cb38a7906", "title": "Oracle and the Ends of Time", "url": "https://seanstuber.com/2020/03/05/oracle-and-the-ends-of-time/", "published_at": "2020-03-05T07:58:43+00:00" }, { "id": "01a0ca51-9e8b-7206-83f8-7d0cb41a5e18", "title": "Math, SQL, and Chess – Lessons from the 8 Queens Puzzle", "url": "https://seanstuber.com/2020/02/22/math-sql-and-chess-lessons-from-the-8-queens-puzzle/", "published_at": "2020-02-23T04:04:04+00:00" }, { "id": "01a0ca51-9e8b-7206-83f8-7d0cb48a5fbb", "title": "Predicates: Joins, Filters, and Pushability", "url": "https://seanstuber.com/2020/02/22/predicates-joins-filters-and-pushability/", "published_at": "2020-02-23T01:40:48+00:00" }, { "id": "01a0ca51-9e8b-7206-83f8-7d0cb501c395", "title": "APEX isn’t special… and that’s why I like it", "url": "https://seanstuber.com/2020/02/01/apex-isnt-special-and-thats-why-i-like-it/", "published_at": "2020-02-01T22:04:13+00:00" } ] posts Claim your blog

Back to seanstuber.com

Blog · corpus.blog/blogs/seanstuber.com/posts

seanstuber.com

seanstuber.com

2026

CMU bug fixed in July DBRU for 19c and 26ai original ↗

23 Aug 2026

See you at KScope!original ↗

15 Jun 2026

Solving Performance Problems with a Touch of Magic original ↗

4 May 2026

Assertions in 26ai original ↗

16 Mar 2026

Advent of Code 2025- Day 11 original ↗

11 Jan 2026

Advent of Code 2025- Day 9 original ↗

2 Jan 2026

2025

Advent of Code 2025- Day 8 original ↗

24 Dec 2025

Advent of Code 2025- Day 7 original ↗

17 Dec 2025

Advent of Code 2025- Day 6 original ↗

14 Dec 2025

Advent of Code 2025- Day 5 original ↗

10 Dec 2025

Advent of Code 2025 – Day 4 original ↗

9 Dec 2025

Advent of Code 2025 – Day 3 original ↗

6 Dec 2025

Advent of Code 2025 – Day 2 original ↗

5 Dec 2025

26ai coming to on-prem in January!original ↗

5 Dec 2025

Advent of Code 2025 – Day 1 original ↗

5 Dec 2025

Creating APEX report with rolling set of columns #JoelKallmanDay original ↗

15 Oct 2025

Duplicating an IG does not duplicate Automatic Row Processing DML original ↗

14 Oct 2025

Using SQL to derive dice distributions in D&D original ↗

29 Jul 2025

Bringing APEX and PL/SQL to D&D original ↗

20 Jul 2025

Interesting bug with nondeterministic functions original ↗

14 May 2025

New Certification and FeedSpot Recognition original ↗

14 Apr 2025

PL/SQL package for 32-bit xoshiro/xoroshiro pseudorandom number generators original ↗

15 Mar 2025

PL/SQL package for 64-bit xoshiro/xoroshiro pseudorandom number generators original ↗

2 Mar 2025

Bit manipulation of large numbers in pl/sql original ↗

17 Feb 2025

Implementing xoshiro256** in PL/SQL original ↗

14 Feb 2025

Advent of Code 2024 – Day 4 original ↗

25 Jan 2025

Advent of Code 2024 – Day 3 original ↗

25 Jan 2025

Advent of Code 2024 – Day 2 original ↗

25 Jan 2025

Advent of Code 2024 – Day 1 original ↗

17 Jan 2025

2024

Exploring the PAIRS OF iterator original ↗

5 Nov 2024

How To Implement Glicko-2 In PL/SQL #JoelKallmanDay original ↗

16 Oct 2024

23ai PL/SQL Dangling Predicates in CASE expressions original ↗

26 Aug 2024

Choosing OpenAI model with Oracle 23ai SELECT original ↗

20 Jul 2024

Using MLE JavaScript function to iterate JSON Keys in SQL original ↗

2 May 2024

Using a Java function to iterate large JSON with many keys.original ↗

6 Mar 2024

How to create a PL/SQL function to iterate JSON Keys for SQL original ↗

3 Mar 2024

2023

How to use and view comments to your parameter changes original ↗

29 Dec 2023

Comparing 19c vs 21c JSON key lists original ↗

5 Dec 2023

How to recursively search JSON with PL/SQL original ↗

4 Dec 2023

Calculating Skewness of a Population original ↗

12 Oct 2023

Calculating Skewness of a Sample #JoelKallmanDay original ↗

11 Oct 2023

23ai adds PING to SQL*Plus original ↗

29 Sept 2023

Pipelined PL/SQL and Java with ODCI original ↗

16 Jul 2023

Working with Table Functions in SQL original ↗

8 Jul 2023

Exiting the OJVM in your db session original ↗

1 Jul 2023

Oracle 23ai interval aggregates original ↗

9 May 2023

Oracle 23ai Boolean support in SQL original ↗

22 Apr 2023

Date/Timestamp Cheat Sheet original ↗

30 Mar 2023

Finding dates of holidays using PL/SQL original ↗

19 Mar 2023

Calculating Binomial Distribution Probabilities in PL/SQL original ↗

18 Mar 2023

Large Number Combinatoric calculations in PL/SQL original ↗

11 Feb 2023

2022

Let NULL work for you #JoelKallmanDay original ↗

11 Oct 2022

Mean, Median, and Mode of summarized data original ↗

23 Sept 2022

Calculating Hypergeometric Distribution probability in PL/SQL original ↗

26 Aug 2022

Working with Collections in SQL original ↗

30 Apr 2022

SQL and Set Theory original ↗

22 Apr 2022

Sending Email with Oracle, Part 10: Pulling it all together original ↗

14 Apr 2022

Sending Email with Oracle, Part 9: Alternative content original ↗

14 Apr 2022

Sending Email with Oracle, Part 8: HTML-formatted content original ↗

14 Apr 2022

Sending Email with Oracle, Part 6: MIME Content original ↗

14 Apr 2022

Sending Email with Oracle, Part 7: UTL_SMTP – Attachments original ↗

17 Mar 2022

Free Falling with PL/SQL original ↗

25 Feb 2022

2021

Sending Email with Oracle, Part 5: UTL_SMTP – Authentication (manual)original ↗

30 Dec 2021

Sending Email with Oracle, Part 3: UTL_SMTP – Introduction original ↗

30 Dec 2021

Sending Email with Oracle, Part 2: APEX_MAIL original ↗

30 Dec 2021

Sending Email with Oracle, Part 4: UTL_SMTP – Authentication (API)original ↗

30 Dec 2021

Sending Email with Oracle, Part 1: UTL_MAIL original ↗

30 Dec 2021

SQL vs Towers of Hanoi original ↗

30 Nov 2021

LDAP to JSON function #JoelKallmanDay original ↗

11 Oct 2021

Solving the Water Jug puzzle with SQL original ↗

8 Oct 2021

Recursive WITH clause join bug original ↗

7 Oct 2021

SQL meets Calculus original ↗

1 Oct 2021

21c My easiest upgrade ever original ↗

22 Aug 2021

In memory of Joel Kallman original ↗

28 May 2021

ORA_COMPLEXITY_CHECK quirks and alternative original ↗

20 Apr 2021

Solving the Four Weights combination puzzle with SQL original ↗

22 Mar 2021

Dynamic Action Link with APEX chart original ↗

21 Mar 2021

How to TNSPING without TNSPING original ↗

18 Mar 2021

Creating DB Links between two Oracle Autonomous databases original ↗

14 Mar 2021

Creating DB Link to Oracle Cloud ADB from an on-premises database original ↗

6 Mar 2021

PUBLIC privileges: reading the DB Version original ↗

26 Feb 2021

LDAP – TNS service name package v2.3 original ↗

20 Feb 2021

How to put an “IF” inside SQL original ↗

19 Feb 2021

If You Shoot Yourself in the Foot… Don’t Reload original ↗

11 Feb 2021

Dates and Timestamps – the TRUNC function original ↗

31 Jan 2021

The 12-Coins Puzzle in PL/SQL original ↗

17 Jan 2021

The 8-Queens Puzzle in PL/SQL original ↗

13 Jan 2021

Counting Query Combinatorics original ↗

9 Jan 2021

2020

Oracle Intervals – Year to Month original ↗

30 Dec 2020

Oracle Intervals – Day to Second original ↗

23 Dec 2020

Oracle Intervals – Overview original ↗

23 Dec 2020

Time Zones, Daylight Saving Time, and Data Types original ↗

19 Nov 2020

Connection Basics original ↗

8 Jun 2020

Date and Timestamp Formats and Structure original ↗

17 May 2020

Data type quirks in Oracle original ↗

8 Apr 2020

Using Correct Data Types original ↗

5 Apr 2020

Oracle and the Ends of Time original ↗

5 Mar 2020

Math, SQL, and Chess – Lessons from the 8 Queens Puzzle original ↗

23 Feb 2020

Predicates: Joins, Filters, and Pushability original ↗

23 Feb 2020

APEX isn’t special… and that’s why I like it original ↗

1 Feb 2020