corpus.blog
41,554 blogs · 4,819,422 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 26aioriginal ↗
23 Aug 2026
See you at KScope!original ↗
15 Jun 2026
Solving Performance Problems with a Touch of Magicoriginal ↗
4 May 2026
Assertions in 26aioriginal ↗
16 Mar 2026
Advent of Code 2025- Day 11original ↗
11 Jan 2026
Advent of Code 2025- Day 9original ↗
2 Jan 2026

2025

Advent of Code 2025- Day 8original ↗
24 Dec 2025
Advent of Code 2025- Day 7original ↗
17 Dec 2025
Advent of Code 2025- Day 6original ↗
14 Dec 2025
Advent of Code 2025- Day 5original ↗
10 Dec 2025
Advent of Code 2025 – Day 4original ↗
9 Dec 2025
Advent of Code 2025 – Day 3original ↗
6 Dec 2025
Advent of Code 2025 – Day 2original ↗
5 Dec 2025
26ai coming to on-prem in January!original ↗
5 Dec 2025
Advent of Code 2025 – Day 1original ↗
5 Dec 2025
Creating APEX report with rolling set of columns #JoelKallmanDayoriginal ↗
15 Oct 2025
Duplicating an IG does not duplicate Automatic Row Processing DMLoriginal ↗
14 Oct 2025
Using SQL to derive dice distributions in D&Doriginal ↗
29 Jul 2025
Bringing APEX and PL/SQL to D&Doriginal ↗
20 Jul 2025
Interesting bug with nondeterministic functionsoriginal ↗
14 May 2025
New Certification and FeedSpot Recognitionoriginal ↗
14 Apr 2025
PL/SQL package for 32-bit xoshiro/xoroshiro pseudorandom number generatorsoriginal ↗
15 Mar 2025
PL/SQL package for 64-bit xoshiro/xoroshiro pseudorandom number generatorsoriginal ↗
2 Mar 2025
Bit manipulation of large numbers in pl/sqloriginal ↗
17 Feb 2025
Implementing xoshiro256** in PL/SQLoriginal ↗
14 Feb 2025
Advent of Code 2024 – Day 4original ↗
25 Jan 2025
Advent of Code 2024 – Day 3original ↗
25 Jan 2025
Advent of Code 2024 – Day 2original ↗
25 Jan 2025
Advent of Code 2024 – Day 1original ↗
17 Jan 2025

2024

Exploring the PAIRS OF iteratororiginal ↗
5 Nov 2024
How To Implement Glicko-2 In PL/SQL #JoelKallmanDayoriginal ↗
16 Oct 2024
23ai PL/SQL Dangling Predicates in CASE expressionsoriginal ↗
26 Aug 2024
Choosing OpenAI model with Oracle 23ai SELECToriginal ↗
20 Jul 2024
Using MLE JavaScript function to iterate JSON Keys in SQLoriginal ↗
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 SQLoriginal ↗
3 Mar 2024

2023

How to use and view comments to your parameter changesoriginal ↗
29 Dec 2023
Comparing 19c vs 21c JSON key listsoriginal ↗
5 Dec 2023
How to recursively search JSON with PL/SQLoriginal ↗
4 Dec 2023
Calculating Skewness of a Populationoriginal ↗
12 Oct 2023
Calculating Skewness of a Sample #JoelKallmanDayoriginal ↗
11 Oct 2023
23ai adds PING to SQL*Plusoriginal ↗
29 Sept 2023
Pipelined PL/SQL and Java with ODCIoriginal ↗
16 Jul 2023
Working with Table Functions in SQLoriginal ↗
8 Jul 2023
Exiting the OJVM in your db sessionoriginal ↗
1 Jul 2023
Oracle 23ai interval aggregatesoriginal ↗
9 May 2023
Oracle 23ai Boolean support in SQLoriginal ↗
22 Apr 2023
Date/Timestamp Cheat Sheetoriginal ↗
30 Mar 2023
Finding dates of holidays using PL/SQLoriginal ↗
19 Mar 2023
Calculating Binomial Distribution Probabilities in PL/SQLoriginal ↗
18 Mar 2023
Large Number Combinatoric calculations in PL/SQLoriginal ↗
11 Feb 2023

2022

Let NULL work for you #JoelKallmanDayoriginal ↗
11 Oct 2022
Mean, Median, and Mode of summarized dataoriginal ↗
23 Sept 2022
Calculating Hypergeometric Distribution probability in PL/SQLoriginal ↗
26 Aug 2022
Working with Collections in SQLoriginal ↗
30 Apr 2022
SQL and Set Theoryoriginal ↗
22 Apr 2022
Sending Email with Oracle, Part 10: Pulling it all togetheroriginal ↗
14 Apr 2022
Sending Email with Oracle, Part 9: Alternative contentoriginal ↗
14 Apr 2022
Sending Email with Oracle, Part 8: HTML-formatted contentoriginal ↗
14 Apr 2022
Sending Email with Oracle, Part 6: MIME Contentoriginal ↗
14 Apr 2022
Sending Email with Oracle, Part 7: UTL_SMTP – Attachmentsoriginal ↗
17 Mar 2022
Free Falling with PL/SQLoriginal ↗
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 – Introductionoriginal ↗
30 Dec 2021
Sending Email with Oracle, Part 2: APEX_MAILoriginal ↗
30 Dec 2021
Sending Email with Oracle, Part 4: UTL_SMTP – Authentication (API)original ↗
30 Dec 2021
Sending Email with Oracle, Part 1: UTL_MAILoriginal ↗
30 Dec 2021
SQL vs Towers of Hanoioriginal ↗
30 Nov 2021
LDAP to JSON function #JoelKallmanDayoriginal ↗
11 Oct 2021
Solving the Water Jug puzzle with SQLoriginal ↗
8 Oct 2021
Recursive WITH clause join bugoriginal ↗
7 Oct 2021
SQL meets Calculusoriginal ↗
1 Oct 2021
21c My easiest upgrade everoriginal ↗
22 Aug 2021
In memory of Joel Kallmanoriginal ↗
28 May 2021
ORA_COMPLEXITY_CHECK quirks and alternativeoriginal ↗
20 Apr 2021
Solving the Four Weights combination puzzle with SQLoriginal ↗
22 Mar 2021
Dynamic Action Link with APEX chartoriginal ↗
21 Mar 2021
How to TNSPING without TNSPINGoriginal ↗
18 Mar 2021
Creating DB Links between two Oracle Autonomous databasesoriginal ↗
14 Mar 2021
Creating DB Link to Oracle Cloud ADB from an on-premises databaseoriginal ↗
6 Mar 2021
PUBLIC privileges: reading the DB Versionoriginal ↗
26 Feb 2021
LDAP – TNS service name package v2.3original ↗
20 Feb 2021
How to put an “IF” inside SQLoriginal ↗
19 Feb 2021
If You Shoot Yourself in the Foot… Don’t Reloadoriginal ↗
11 Feb 2021
Dates and Timestamps – the TRUNC functionoriginal ↗
31 Jan 2021
The 12-Coins Puzzle in PL/SQLoriginal ↗
17 Jan 2021
The 8-Queens Puzzle in PL/SQLoriginal ↗
13 Jan 2021
Counting Query Combinatoricsoriginal ↗
9 Jan 2021

2020

Oracle Intervals – Year to Monthoriginal ↗
30 Dec 2020
Oracle Intervals – Day to Secondoriginal ↗
23 Dec 2020
Oracle Intervals – Overvieworiginal ↗
23 Dec 2020
Time Zones, Daylight Saving Time, and Data Typesoriginal ↗
19 Nov 2020
Connection Basicsoriginal ↗
8 Jun 2020
Date and Timestamp Formats and Structureoriginal ↗
17 May 2020
Data type quirks in Oracleoriginal ↗
8 Apr 2020
Using Correct Data Typesoriginal ↗
5 Apr 2020
Oracle and the Ends of Timeoriginal ↗
5 Mar 2020
Math, SQL, and Chess – Lessons from the 8 Queens Puzzleoriginal ↗
23 Feb 2020
Predicates: Joins, Filters, and Pushabilityoriginal ↗
23 Feb 2020
APEX isn’t special… and that’s why I like itoriginal ↗
1 Feb 2020
Next