Erik van Roon
@evrocs.bsky.social
- Oracle DB Dev
- Oracle ACE Pro ♠️
- Symposium42 - https://sym42.org/
- Rambling fool
By default assume I'm not serious
Tweeted opinions are the one & only truth, and probably unfounded
- Oracle ACE Pro ♠️
- Symposium42 - https://sym42.org/
- Rambling fool
By default assume I'm not serious
Tweeted opinions are the one & only truth, and probably unfounded
Reposted by Erik van Roon
Best Christmas 2025 present ever! 🙌
The new #SQLcl release brings a tiny but mighty new feature! Goodbye pesky little line numbers! 🧹
A shoutout to the SQLcl Dev team to get this in! 👍
The new #SQLcl release brings a tiny but mighty new feature! Goodbye pesky little line numbers! 🧹
A shoutout to the SQLcl Dev team to get this in! 👍
Tiny but mighty new SQLcl feature
Last week, a new version of SQLcl was released, SQLcl 25.4. The release contains a lot of cool new features, but there is one tiny one in it that came thanks to yours truly. Of course, I can only take credit for filing an enhancement request, tracking down the Dev manager, and pestering him until he kindly agreed. And truthfully, it didn't really involve pestering.
www.geraldonit.com
December 23, 2025 at 2:01 PM
Best Christmas 2025 present ever! 🙌
The new #SQLcl release brings a tiny but mighty new feature! Goodbye pesky little line numbers! 🧹
A shoutout to the SQLcl Dev team to get this in! 👍
The new #SQLcl release brings a tiny but mighty new feature! Goodbye pesky little line numbers! 🧹
A shoutout to the SQLcl Dev team to get this in! 👍
Reposted by Erik van Roon
Oracle SQLcl Version 25.4 is available, NOW.
Improvements for both 👩💻 and 🤖!
Improvements for both 👩💻 and 🤖!
Previously on @thatjeffsmith... Your favorite Oracle database CLI and MCP just got updated
Your favorite Oracle database CLI and MCP just got updated
Previously on @thatjeffsmith... Your favorite Oracle database CLI and MCP just got updated
www.thatjeffsmith.com
December 17, 2025 at 4:39 PM
Oracle SQLcl Version 25.4 is available, NOW.
Improvements for both 👩💻 and 🤖!
Improvements for both 👩💻 and 🤖!
Reposted by Erik van Roon
I ... am ... pumped....
December 3, 2025 at 10:02 PM
I ... am ... pumped....
Reposted by Erik van Roon
Heading out on the Oracle ACE Adventure to Cadbury World
November 30, 2025 at 9:58 AM
Heading out on the Oracle ACE Adventure to Cadbury World
Reposted by Erik van Roon
A little pre fun for (some of) our speakers and organisation for the #dcd25 day at our speakers dinner.
They all can't wait for tomorrow!
#thankyou #oracle #octemea25
They all can't wait for tomorrow!
#thankyou #oracle #octemea25
November 12, 2025 at 8:35 PM
A little pre fun for (some of) our speakers and organisation for the #dcd25 day at our speakers dinner.
They all can't wait for tomorrow!
#thankyou #oracle #octemea25
They all can't wait for tomorrow!
#thankyou #oracle #octemea25
Reposted by Erik van Roon
Go to apexworld.nloug.nl to submit your abstract
November 12, 2025 at 9:24 AM
Go to apexworld.nloug.nl to submit your abstract
Reposted by Erik van Roon
Full house for @evrocs.bsky.social talking about sqlcl at #DOUGDay2025
@oracleace.bsky.social @sym42.bsky.social
@oracleace.bsky.social @sym42.bsky.social
November 5, 2025 at 1:33 PM
Full house for @evrocs.bsky.social talking about sqlcl at #DOUGDay2025
@oracleace.bsky.social @sym42.bsky.social
@oracleace.bsky.social @sym42.bsky.social
Reposted by Erik van Roon
Developers' track at #DOUGDay2025 is very popular. It must be because of the topic - SQLcl - or the speaker @evrocs.bsky.social
@oracleace.bsky.social @sym42.bsky.social
@oracleace.bsky.social @sym42.bsky.social
November 5, 2025 at 1:39 PM
Developers' track at #DOUGDay2025 is very popular. It must be because of the topic - SQLcl - or the speaker @evrocs.bsky.social
@oracleace.bsky.social @sym42.bsky.social
@oracleace.bsky.social @sym42.bsky.social
Reposted by Erik van Roon
The developer track of #DOUGDay2025 starts of with @evrocs.bsky.social explaining all about #SQL Macros
November 5, 2025 at 10:10 AM
The developer track of #DOUGDay2025 starts of with @evrocs.bsky.social explaining all about #SQL Macros
Reposted by Erik van Roon
What an afternoon we had at Dushanbe American Space!
Students and young professionals, full of energy and curiosity, did not stop asking questions.
Thank you Rustam Khodjaev for inviting us!
@alexnuijten.bsky.social @evrocs.bsky.social @oraclesean.com Sandesh Rao
Students and young professionals, full of energy and curiosity, did not stop asking questions.
Thank you Rustam Khodjaev for inviting us!
@alexnuijten.bsky.social @evrocs.bsky.social @oraclesean.com Sandesh Rao
October 29, 2025 at 6:27 PM
What an afternoon we had at Dushanbe American Space!
Students and young professionals, full of energy and curiosity, did not stop asking questions.
Thank you Rustam Khodjaev for inviting us!
@alexnuijten.bsky.social @evrocs.bsky.social @oraclesean.com Sandesh Rao
Students and young professionals, full of energy and curiosity, did not stop asking questions.
Thank you Rustam Khodjaev for inviting us!
@alexnuijten.bsky.social @evrocs.bsky.social @oraclesean.com Sandesh Rao
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!
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!
October 3, 2025 at 4:36 PM
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!
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!
Reposted by Erik van Roon
Joel Kallman Day 2025 : Announcement
oracle-base.com/blog/2025/09...
#JoelKallmanDay
@oracleace @OracleAPEX #orclapex @OracleDatabase
oracle-base.com/blog/2025/09...
#JoelKallmanDay
@oracleace @OracleAPEX #orclapex @OracleDatabase
September 24, 2025 at 6:21 AM
Joel Kallman Day 2025 : Announcement
oracle-base.com/blog/2025/09...
#JoelKallmanDay
@oracleace @OracleAPEX #orclapex @OracleDatabase
oracle-base.com/blog/2025/09...
#JoelKallmanDay
@oracleace @OracleAPEX #orclapex @OracleDatabase
Subtly downgrade a band:
Veggie Loaf
Veggie Loaf
Subtly downgrade a band:
Tin Zeppelin
Tin Zeppelin
Subtly downgrade a band:
Eight Inch Nails
Eight Inch Nails
September 27, 2025 at 8:36 PM
Subtly downgrade a band:
Veggie Loaf
Veggie Loaf
At @pougorg.bsky.social #poug2025 for some reason nobody overruns their session.
Well, not more than once anyway.
Well, not more than once anyway.
September 6, 2025 at 2:31 PM
At @pougorg.bsky.social #poug2025 for some reason nobody overruns their session.
Well, not more than once anyway.
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!
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!
September 5, 2025 at 7:21 AM
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!
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!
Reposted by Erik van Roon
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.
Currently waiting in Hannover for the arrival of @kibeha.dk so we can do the rest together.
August 30, 2025 at 11:11 AM
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.
Currently waiting in Hannover for the arrival of @kibeha.dk so we can do the rest together.
Reposted by Erik van Roon
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
blog.longacre.ch/2025/08/orac...
@oracleace.bsky.social #orclapex
August 18, 2025 at 8:08 AM
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
blog.longacre.ch/2025/08/orac...
@oracleace.bsky.social #orclapex
Reposted by Erik van Roon
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
Schema annotations have been backported to 19.28
These enable you to add key-value metadata to describe tables, columns, and other database objects
August 1, 2025 at 9:01 AM
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
Schema annotations have been backported to 19.28
These enable you to add key-value metadata to describe tables, columns, and other database objects
Reposted by Erik van Roon
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
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
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...
simpleoracledba.blogspot.com
July 29, 2025 at 7:01 AM
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
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
Reposted by Erik van Roon
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
Automatically place any unaggregated columns in the select into the group by clause
SELECT col1, col2, ...
FROM ..
GROUP BY ALL -- generates col1, col2
July 16, 2025 at 7:20 AM
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
Automatically place any unaggregated columns in the select into the group by clause
SELECT col1, col2, ...
FROM ..
GROUP BY ALL -- generates col1, col2
Reposted by Erik van Roon
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 …
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 …
July 16, 2025 at 7:20 AM
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 …
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 …
Reposted by Erik van Roon
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...
dbLinter can help you sort your join and filter criteria and spot issues like this.
www.salvis.com/blog/2025/07...
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...
www.salvis.com
July 12, 2025 at 3:52 PM
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...
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.
A new post (about an old feature) - "Mixed Feelings About MERGE"
db-oriented.com/2025/07/12/m...
@oracleace.bsky.social #ACED @sym42.bsky.social
db-oriented.com/2025/07/12/m...
@oracleace.bsky.social #ACED @sym42.bsky.social
Mixed Feelings About MERGE - @DBoriented
Why Oracle's MERGE Statement Fails Where INSERT/UPDATE Succeeds
db-oriented.com
July 12, 2025 at 11:23 AM
Learned something I didn't know, but should have known, about the merge statement.
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...
Even in court.
Georgia court throws out earlier ruling that relied on fake cases made up by AI • The Register share.google/G3lwklID3iil...
Georgia court vacates order citing AI-invented caselaw
: 'We are troubled by the citation of bogus cases in the trial court’s order'
share.google
July 10, 2025 at 8:18 AM
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...
Even in court.
Georgia court throws out earlier ruling that relied on fake cases made up by AI • The Register share.google/G3lwklID3iil...