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
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...
Reposted by Erik van Roon
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.
📢 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
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
PL/SQL code quality checks in VS Code with dbLinter
YouTube video by United Codes
youtu.be
July 9, 2025 at 11:50 AM
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.
Reposted by Erik van Roon
📢 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
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
PL/SQL code quality checks in VS Code with dbLinter
YouTube video by United Codes
youtu.be
July 9, 2025 at 10:17 AM
Reposted by Erik van Roon
we have an official MCP Server for Oracle Database as of...today
July 7, 2025 at 6:38 PM
we have an official MCP Server for Oracle Database as of...today
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 🤬
Looking at you Oracle 🤬
June 10, 2025 at 11:44 AM
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 🤬
Looking at you Oracle 🤬
Reposted by Erik van Roon
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
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
With great pleasure, we announce the promotion to Oracle ACE Director of Mirela Ardelean. Mirela has shown relentless dedication to the Oracle community & deep technical expertise. ♠️
Thanks for the recommendation, Monica Godoy, Sandesh Rao, and Mike Dietrich!
ace.oracle.com/apex/ace/pro...
Thanks for the recommendation, Monica Godoy, Sandesh Rao, and Mike Dietrich!
ace.oracle.com/apex/ace/pro...
June 2, 2025 at 7:36 PM
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
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