Lightnews — Scholar-powered news

Erik van Roon @evrocs.bsky.social · 10d

😢 Such a pity

Erik van Roon @evrocs.bsky.social · 11d

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!

1 1 4

Reposted by Erik van Roon

Tim Hall @oraclebase.bsky.social · 20d

Joel Kallman Day 2025 : Announcement

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

#JoelKallmanDay

@oracleace @OracleAPEX #orclapex @OracleDatabase

1 13 20

Erik van Roon @evrocs.bsky.social · 16d

Subtly downgrade a band:

Veggie Loaf

Sean Scott @oraclesean.com · 20d

Subtly downgrade a band:

Tin Zeppelin

🩵Bolian Boo!👻 @bolianblue.bsky.social · 20d

Subtly downgrade a band:

Eight Inch Nails

6 1

Erik van Roon @evrocs.bsky.social · Sep 6

4

Erik van Roon @evrocs.bsky.social · Sep 6

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

1 7

Erik van Roon @evrocs.bsky.social · Sep 5

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!

5 11

Reposted by Erik van Roon

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha.dk · Sep 2

#POUG2025

1 2 3

Erik van Roon @evrocs.bsky.social · Aug 30

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

3

Erik van Roon @evrocs.bsky.social · Aug 30

Train and then tram to a location near the motorway 😁

1

Erik van Roon @evrocs.bsky.social · Aug 30

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.

2 10

Erik van Roon @evrocs.bsky.social · Aug 27

Congratularions, Lino!

1

Reposted by Erik van Roon

Niall Mc Phillips @niallmcp.bsky.social · Aug 18

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

1 4

Reposted by Erik van Roon

Chris Saxon @chrisrsaxon.bsky.social · Aug 1

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

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

1 5 8

Reposted by Erik van Roon

Piet de Visser @pdevisser.bsky.social · Jul 29

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

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

2 3 6

Reposted by Erik van Roon

Chris Saxon @chrisrsaxon.bsky.social · Jul 16

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

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

2 2 13

Reposted by Erik van Roon

Chris Saxon @chrisrsaxon.bsky.social · Jul 16

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 …

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

3 1 10

Reposted by Erik van Roon

Philipp Salvisberg @salvis.com · Jul 12

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...

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

8 8

Erik van Roon @evrocs.bsky.social · Jul 12

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

Oren Nakdimon @nakdimon.bsky.social · Jul 12

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

Mixed Feelings About MERGE - @DBoriented

Why Oracle's MERGE Statement Fails Where INSERT/UPDATE Succeeds

db-oriented.com

3

Erik van Roon @evrocs.bsky.social · Jul 10

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...

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

Reposted by Erik van Roon

Philipp Salvisberg @salvis.com · Jul 9

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.

Philipp Hartenfeller @hartenfeller.dev · Jul 9

📢 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

PL/SQL code quality checks in VS Code with dbLinter

YouTube video by United Codes

youtu.be

2 5

Reposted by Erik van Roon

Philipp Hartenfeller @hartenfeller.dev · Jul 9

📢 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

PL/SQL code quality checks in VS Code with dbLinter

YouTube video by United Codes

youtu.be

1 4 11

Reposted by Erik van Roon

Jeff Smith @thatjeffsmith.com · Jul 7

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

1 7 21

Erik van Roon @evrocs.bsky.social · Jun 20

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

3

Erik van Roon @evrocs.bsky.social · Jun 16

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]