Erik van Roon

😢 Such a pity

Two weeks from today I'll be talkinig about SQL Macros at #HrOUG2025 in Rovinj, Croatia.
That alone should be enough to attend 😁
But apart from that there are loads of other speakers and since it's the 30th (!!!) time, I expect a lot of celebration as well.
There may still be time to get a ticket!

Joel Kallman Day 2025 : Announcement

oracle-base.com/blog/2025/09...

#JoelKallmanDay

@oracleace @OracleAPEX #orclapex @OracleDatabase

Subtly downgrade a band:

Veggie Loaf

At @pougorg.bsky.social #poug2025 for some reason nobody overruns their session.
Well, not more than once anyway.

And so, the 10th @pougorg.bsky.social #POUG25 starts.
The axeman @ora600pl.bsky.social opening the celebratory champagne bottle the only logical way.
If you don't hear from me again know that I went out having the best of times!

#POUG2025

You see that bench?
Sit on it and stay quiet.
I'll pick you up september 2026.

Train and then tram to a location near the motorway 😁

First part of the trip by car to Poznań for #poug2025 done.
Currently waiting in Hannover for the arrival of @kibeha.dk so we can do the rest together.

Congratularions, Lino!

A recent blog post about the order of execution of processes in Oracle APEX: How Application and Page Processes really execute at the same process point.

blog.longacre.ch/2025/08/orac...

@oracleace.bsky.social #orclapex

Example defining annotations on a table and column in Oracle Database 19.28

With all the new stuff in the 23ai RUs, it can be easy to overlook some cool changes in 19c such as

Schema annotations have been backported to 19.28

These enable you to add key-value metadata to describe tables, columns, and other database objects

Oracle23ai - a SQL-Macro for Epoch - The Better version. TL;DR: I had a function to produce "Epoch", similar to python. When I tried to speed up function-calls by using a macro I found an interesti...

The "epoch" function got better by turning it into an SQL-Macro.
simpleoracledba.blogspot.com/2025/07/orac...

With Thanks to Erik, Jonathan and Priit for their remarks.
/cc @evrocs.bsky.social @jloracle.bsky.social @ppiipuu.bsky.social
@oracleace.bsky.social

GROUP BY ALL (23.9) Automatically generate GROUP BY clause with all unaggregated selected columns Example of this on the hr.employees table

Group by enhancements

Automatically place any unaggregated columns in the select into the group by clause

SELECT col1, col2, ...
FROM ..
GROUP BY ALL -- generates col1, col2

Non-positional insert statements (23.9) INSERT INTO … SET col1 = val1, col2 = val2, … for row-based inserts INSERT INTO … BY NAME SELECT … to match query column aliases to column names

Non-positional inserts

Assign column values in the SET clause for row-based inserts:

INSERT INTO … SET col1 = val1, col2 = val2, ...

Match columns from the source table to the target table in INSERT-SELECT by name rather than position with

INSERT INTO … BY NAME SELECT …

Outer Joining With ANSI SQL-89 and SQL-92 Introduction I recently implemented a quick fix for the rule G-3130 to transform queries to ANSI SQL-92 syntax. One of the challenges was to handle Oracle’s outer-join syntax (+). In ANSI SQL-89, join...

Do your outer join queries produce more rows than expected? In this blog post, I show a strange result when using filter predicates in the join clause.

dbLinter can help you sort your join and filter criteria and spot issues like this.

www.salvis.com/blog/2025/07...

Learned something I didn't know, but should have known, about the merge statement.

Georgia court vacates order citing AI-invented caselaw : 'We are troubled by the citation of bogus cases in the trial court’s order'

So, after the times when "the first hit of a google search leads to the one and only truth" we are now in the era of "want to know the truth, ask chatgpt".

Even in court.

Georgia court throws out earlier ruling that relied on fake cases made up by AI • The Register share.google/G3lwklID3iil...

Do you have SQL or PL/SQL code? Check your code quality against more than 150 rules. Configure your rule set. Apply quick fixes for chosen issues or even all fixable issues in a file. @hartenfeller.dev shows how to get started with dbLinter.

YouTube video by United Codes PL/SQL code quality checks in VS Code with dbLinter

📢 dbLinter is officially in free preview!

Get automated quality checks for your #oracle #plsql code right in VS Code.
Customize rules, severities, and naming conventions in our app.
Watch it in action: youtu.be/V-ePBfUFhhk #dbLinter #orclAPEX #VSCode

we have an official MCP Server for Oracle Database as of...today

It's nice that you can pick her up again in only 2 weeks 👍

I always bluntly refuse for exactly these reasons, plus I pay extra for extra legroom which I don't intend to give up because *they* can't do basic math: [cubic meters of overhead compartment space] / [number of seats] = [max size of carry-on]

I'm pretty confident there will be further development.
It's just that being able to use these things in with clauses is such a basic feauture (note: not saying easy to implement) that if I was running the show (thank god I'm not) it would never have been releases without it.

I know. Very annoying too.
Very nice feature, but it's time we get a new and improved one IMHO.

Screenshot of errormessage telling me I can't use SQL macros in a with clause

Do you know that feeling when you're with the one you deeply love, but suddenly, out of the blue, they do this annoying thing again, and in that moment there's nothing you want more than get a divorce?

Looking at you Oracle 🤬

Terminal (CLI) life can be pleasant, if not enjoyable! #Oracle gives you what you need, and then some.

I am honored to be promoted to Oracle ACE Director and I am proud to be the first ACED in Romania.
Many thanks to Monica Godoy for nominating me, and to @mikedietrichde.com, Sandesh Rao, Andreea Munteanu, Stefan Dobre, @basheerkhan.bsky.social, @rhjmartens.bsky.social for supporting my nomination