Erik van Roon

I just realized it will be Friday the 13th (November) that I will be speaking at DB World 2026 😱. Don't worry, I don't see any J(a)SON on the agenda 😉. You can safely get your ticket: nloug.nl/en/events/db... I'm speaking after afternoon break. #DBWorld26 #octemea2026 #nlOUG @nloug.bsky.social

I've started a blog series on assertion locking. blogs.oracle.com/sql/assertio... blogs.oracle.com/sql/assertio... blogs.oracle.com/sql/assertio...

I just *love* his problem solving skills

You can't pass parameters to views But with macros in Oracle AI Database you can create view-like objects that do have parameters These received a big upgrade in 23.26.4 with macro objects: CREATE MACRO ... IS SELECT ... @chrisrsaxon.bsky.social shows how buff.ly/9U00Fuy

📣 Call for Papers - APEX World is open 📅 18–19 March 2027, ReeHorst, Ede 🕒️ Talks (45 min) or hands-on labs (1.5 h) on APEX and its ecosystem: SQL, PL/SQL, JS, CI/CD, AI agents & more ❗️ Deadline: 15 Nov, 23:59 CET 👉️ Submit: abstracts.nloug.nl #orclAPEX #APEXWorld

Our keynote speaker is Daniel Overby Hansen with "Can’t We All Be Friends? How Developers Help DBAs Patch the Database." 🤝🛠️💻 Get your tickets at nloug.nl/en/events/db... before they sell out! 🎟️ 🔥🔥🔥🔥 #dbworld #nloug #oracle

#JoelKallmanDay is tomorrow (Wednesday 14th October). Joel Kallman Day 2026 : Announcement oracle-base.com/blog/2026/09... @oracleace @OracleDatabase @OracleDevs @OracleAPEX #orclapex @OracleREST

Friday fun: what is the result of select nvl(nullif (1=2, false), '1'); Makes me think much longer than it should.

📣 The Call for Papers for APEX World 2027 is open! 📅 18–19 March 2027, ReeHorst, Ede 🕒️ Talks (45 min) or hands-on labs (1.5 h) on APEX and its ecosystem: SQL, PL/SQL, JS, CI/CD, AI agents & more. ❗️ Deadline: Sun 15 Nov, 23:59 CET 👉️ Submit: abstracts.nloug.nl #orclAPEX #APEXWorld

Better get your post ready....

Visiting St. Peter's Basilica. By the time I get in, I will probably be well-done and ready to be served. 😁

Ask TOM Live has been running over 8 years now! That's nearly 100 sessions covering Oracle #SQL I've hosted - most of which included live demos As requested by an attendee yesterday I've uploaded all my scripts for past sessions to GitHub Get them at: github.com/ChrisSaxonOr...

About to start #ITOUG26 And if you start with a session by @nakdimon.bsky.social the event has a rock solid foundation to build on.

About to take off for a week in Rome. Excited to see a famous city that for some reason I have never seen before and to attend ITOUG on Wednesday.

Erik will talk about cats. 🐱 Only at #poug2026

Nearing the end of another fantastic #poug2026

Standing room for @chandlerdba.bsky.social session at #poug2026

Database conference has started #POUG2026

Oracle AI Database makes outer joins the default in Join-to-One because inner joins may filter rows unintentionally. Here is why I think the join type should be explicit. www.salvis.com/blog/2026/08...

People say “you could count that on the fingers of one hand” not realizing that is a 5 bit value meaning you can count to 31 on one hand and 1023 on two hands

🤔 🤣

I continue to get a chuckle about the fact that the IT industry always needs to reinvent concepts that have existed pretty much forever. Was recently watching some content about AI agent memory, and it discusses at length its evolution from: 1/6

Remember SQLcl’s SCRIPT command? Why did it disappear from modern environments, and how can we bring it back? Both in standalone SQLcl and in the SQLcl embedded in SQL Developer for VS Code? www.salvis.com/blog/2026/07...

There’s static SQL and dynamic SQL, but in between there’s also SQL that’s “dynamic at parse-time,” known as polymorphic (meaning it can change “shape”.) This talk, run by @kibeha.dk, looks at different ways to achieve this. #POUG2026 last 11 tickets: poug.org/edycja/poug2...

So, nested with? Sure, thanks I guess. Multi-nested with? Yeah. Whatever. Wait, what's this, almost as a side note? Using macros in a with clause? Yes! Finally! Yesterday please! And backport to 19c please. Did I say please yet? Please!

Friday thoughts ... Stop writing code from your "happy place" :-) connor-mcdonald.com/2026/06/26/b...

Can syntax diagrams be generated from the APEXlang EBNF grammar? Yes! This post shows the conversion to W3C EBNF, the tooling used, and the resulting railroad diagrams. www.salvis.com/blog/2026/06...

Mrs W (MIll House Millinery) has a pop-up shop in Newmarket, 24th June - 10 July. She is running workshops where you make your own fascinator, showing and selling her hats & fascinators, and will be delighted to talk to you about the talks & workshops she does! www.facebook.com/reel/8370715...

Welcome to #POUG2026! The fridge is full of beers. Help yourself and take as many as you like. But there’s one sacred rule: one beer must always remain. The beers & @franckpachot.bsky.social will be in Krakow on September 4-5th, but will you? www.poug.org

Next for me at #MakeIT2026 is a Kim Berg Hansen-Lab 😁 @kibeha.dk @sym42.bsky.social @oracleace.bsky.social

First session I attend at #MakeIT2026 By @kibeha.dk The start of a couple of exiting days

My first visit to Slovenia, I'm excited to be a speaker at SIOUG MakeIT 2026! I'm on twice tomorrow: - Visualizing PL/SQL with PL/Scope, 26ai Property Graph and APEX Graph Plug-in - 3-hour Hands-On-Lab on analytic functions. Check it out: makeit.si #MakeIT2026 #OracleDB #OracleAPEX #OracleACE

Next week: @oraesque.bsky.social “utPLSQL – The Perfect Testing Tool for Lazy People”. While waiting, check out my interview with veteran Mariusz Masewicz on avoiding weekend debugging: [https://how2ora-en.blogspot.com/2026/05/interview-with-mariusz-masewicz-man-who.html] 🎙️ Don't miss it!

My venue this afternoon. Come join my session at 3PM on 26ai assertions new feature. #apexconn26

(re)connect doorbell to phone... -Open App -Hit the + -Select doorbell -Select wifi -Scan this QR code... (no alternatives) Really? This was designed, built, tested (how?) and released without anybody thinking "wait a minute?" Don't worry I'll work around it, but not everybody will. Idiots.

Another great webinar from #POUG x #PWOW comin up. The one and only @oraesque.bsky.social will tell you all you need to know to turn unit testing from a time consuming job that keeps you from developing into a click of a button. May 27 at 20:00 CEST pwowwebinar3.konfeo.com/en/groups

Add this to all the other reasons why you really should c9mento Krakow in September, and I really don't understand why you didn't get a ticket yet 🫤

Another quarter Another batch of new Oracle #SQL features in the 23.26.2 RU 😀 See the complete list at docs.oracle.com/en/database/... Here are some of the highlights - which are your favourites?

New version of utPLSQL \o/ www.linkedin.com/posts/jacek-...

It's official, our Skills for Oracle AI Database github.com/oracle/skills Get started, simply: npx skills add oracle/skills

New bugfixing method: Fix-by-typo

There seems to be a school of thought in the tech community that a robust knowledge SQL is now optional. My thoughts are that the exact opposite is true: Learning SQL is more important than ever. connor-mcdonald.com/2026/04/22/s...

Good point by Connor to add tiebreakers to the order by clause. I will add: do NOT use default RANGE BETWEEN but please explicitly use ROWS BETWEEN ! www.kibeha.dk/2013/02/rows...

Get Oracle Partition High Values as VARCHAR2 types instead of LONG in Oracle 19c and earlier (new blog). There's also some data 23/26ai data dictionary internals! tanelpoder.com/posts/oracle...

When you feel insulted, but don't have very strong counter arguments 😢

Assertions for data integrity on a less-than-ideal data model. www.kibeha.dk/2026/03/asse... Or "How I could have used assertions 25 years ago when I worked with Concorde XAL"... #OrclDB #SQL #Assertions #OracleACE

😮

📣 26ai is now available for download, x86-64 bit Linux distributions. www.oracle.com/database/tec...

www.youtube.com/watch?v=dNvI...

Finally...