Erik van Roon @evrocs.bsky.social · 17/09/2026Visiting St. Peter's Basilica. By the time I get in, I will probably be well-done and ready to be served. 😁 131
Reposted by Erik van RoonChris Saxon @chrisrsaxon.bsky.social · 16/09/2026Ask 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...github.comGitHub - ChrisSaxonOra/office-hours: Office Hours scriptsOffice Hours scripts. Contribute to ChrisSaxonOra/office-hours development by creating an account on GitHub. 053
Erik van Roon @evrocs.bsky.social · 16/09/2026About to start #ITOUG26 And if you start with a session by @nakdimon.bsky.social the event has a rock solid foundation to build on. 081
Erik van Roon @evrocs.bsky.social · 13/09/2026The only proper way to eat fries. Next: learn how to make proper fries, not 'French' fries, those aren't fries. 231
Erik van Roon @evrocs.bsky.social · 13/09/2026About 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. 060
Reposted by Erik van RoonMonika Lewandowska @monikalewandowska.bsky.social · 05/09/2026Erik will talk about cats. 🐱 Only at #poug2026 092
Erik van Roon @evrocs.bsky.social · 05/09/2026Standing room for @chandlerdba.bsky.social session at #poug2026 091
Reposted by Erik van RoonIlmar Kerm @ilmarkerm.eu · 04/09/2026Database conference has started #POUG2026 0121
Reposted by Erik van RoonPhilipp Salvisberg @salvis.com · 29/08/2026Oracle 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...salvis.comImplicit Outer Joins in Join-to-One: Feature or Flaw?Background As you probably know, I’m maintaining a parser for grammars used in SQL files for Oracle AI Database and PostgreSQL. As a result, I check for new statements and clauses in every version of ... 031
Erik van Roon @evrocs.bsky.social · 29/08/2026Why would he? Nobody's talking about the Epstein files anymore.... 010
Reposted by Erik van RoonRoger MacNicol @rogermacnicol.bsky.social · 26/08/2026People 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 071
Reposted by Erik van RoonConnor McDonald on Database and SQL @connormcd.bsky.social · 14/08/2026I 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 2124
Erik van Roon @evrocs.bsky.social · 11/08/2026Last Sunday. Looking for flights. Found direct flights. Convenient times. Then I saw the better option. Same company also offers leaving 10 min later, giving 65% more time to enjoy that wonderful travel experience due to an added layover, for a mere 35% higher price. Sounds like the perfect deal. 020
Erik van Roon @evrocs.bsky.social · 25/07/2026If I get this working, you're well out of the danger zone 😜 100
Erik van Roon @evrocs.bsky.social · 25/07/2026Philipp, have I told you lately that I love you? You made me very happy with this post. I will play with this soon when I find the time. 110
Reposted by Erik van RoonPhilipp Salvisberg @salvis.com · 25/07/2026Remember 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...salvis.comThe Return of SQLcl’s SCRIPT CommandIntroduction The script command was introduced with SQLcl 4.2. It is based on JSR 223, the Java Scripting API, and makes it possible to run JavaScript from SQLcl. This adds client-side control flow, f... 111
Reposted by Erik van RoonPolish Oracle User Group @pougorg.bsky.social · 23/07/2026There’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... 042
Erik van Roon @evrocs.bsky.social · 06/07/2026Are you usually in the habit to flush just for the heck of it? 🤔 110
Erik van Roon @evrocs.bsky.social · 02/07/2026I'd seen that. Hence the "please" and "yesterday". My experience tells me to start begging early whenever words like "future release", "soon", "almost there" or "near future" appear in the same sentence as "26ai" 😁 But thanks! 020
Erik van Roon @evrocs.bsky.social · 01/07/2026So, 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! 130
Erik van Roon @evrocs.bsky.social · 27/06/2026You used to work in Iceland? 😮 Genuinely envious now. 110
Reposted by Erik van RoonConnor McDonald on Database and SQL @connormcd.bsky.social · 26/06/2026Friday thoughts ... Stop writing code from your "happy place" :-) connor-mcdonald.com/2026/06/26/b...connor-mcdonald.comBlue Sky Programming – The Optimism TrapMany years ago, before I joined Oracle, I was working on a major modernisation project. We were replacing an existing non-Oracle system with an entirely new Oracle database application written from… 271
Reposted by Erik van RoonPhilipp Salvisberg @salvis.com · 19/06/2026Can 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...salvis.comSyntax Diagrams for APEXlangIntroduction The APEXlang API Reference documentation went live a few days ago. You can also download the APEXlang EBNF grammar. In this post, Kris Rice explains the value of having an EBNF. Since the... 011
Reposted by Erik van RoonMartin Widlake @martinwidlake.bsky.social · 10/06/2026Mrs 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...facebook.com 041
Reposted by Erik van RoonPolish Oracle User Group @pougorg.bsky.social · 03/06/2026Welcome 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 072
Erik van Roon @evrocs.bsky.social · 02/06/2026Ze willen graag terug naar de 18e eeuw. Je weet wel: vroeger. Die magische periode toen alles nog goed was. 010
Erik van Roon @evrocs.bsky.social · 27/05/2026Next for me at #MakeIT2026 is a Kim Berg Hansen-Lab 😁 @kibeha.dk @sym42.bsky.social @oracleace.bsky.social 020
Erik van Roon @evrocs.bsky.social · 27/05/2026First session I attend at #MakeIT2026 By @kibeha.dk The start of a couple of exiting days 020
Reposted by Erik van RoonKim Berg Hansen: SQL ♠ 🤓 👨🍳 🍺 @kibeha.dk · 26/05/2026My 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 094
Reposted by Erik van RoonMonika Lewandowska @monikalewandowska.bsky.social · 21/05/2026Next 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: [how2ora-en.blogspot.com/2026/05/int…] 🎙️ Don't miss it! 031
Erik van Roon @evrocs.bsky.social · 21/05/2026Just be happy you weren't there last Monday. Lines for security went on until past the check in counters. It was the first day of reorganized security "to make it more efficient". God knows what they've optimized in luggage handling today😕 010
Erik van Roon @evrocs.bsky.social · 19/05/2026It's the main reason I love cats. They always give you an excuse to do absolutely nothing. 020
Erik van Roon @evrocs.bsky.social · 18/05/2026Last I saw him he was pretty much alive, so my guess would be: one of his victims. 000
Erik van Roon @evrocs.bsky.social · 18/05/2026Are those canons to make sure people pay attention, so the message comes across? 110
Reposted by Erik van RoonToon Koppelaars @toonkoppelaars.bsky.social · 18/05/2026My venue this afternoon. Come join my session at 3PM on 26ai assertions new feature. #apexconn26 174
Erik van Roon @evrocs.bsky.social · 14/05/2026(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.static.klipy.comDrake's Disappointed ShrugALT: Drake's Disappointed Shrug 010
Erik van Roon @evrocs.bsky.social · 10/05/2026Another 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 053
Erik van Roon @evrocs.bsky.social · 04/05/2026Don't tell me you really need a windows user to explain to you it's called x-window. Singular, not plural. 😁 020
Erik van Roon @evrocs.bsky.social · 04/05/2026Add 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 🫤 030
Erik van Roon @evrocs.bsky.social · 03/05/2026There you go. It's fixed. Incredible that it doesn't use your new profile pic a year and a half in advance 🤣 120
Reposted by Erik van RoonChris Saxon @chrisrsaxon.bsky.social · 01/05/2026Another 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?docs.oracle.comOracle AI Database New FeaturesThis book describes the new features in Oracle AI Database 26ai. 131