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
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
You see that bench?
Sit on it and stay quiet.
I'll pick you up september 2026.
Sit on it and stay quiet.
I'll pick you up september 2026.
August 30, 2025 at 5:48 PM
You see that bench?
Sit on it and stay quiet.
I'll pick you up september 2026.
Sit on it and stay quiet.
I'll pick you up september 2026.
Train and then tram to a location near the motorway 😁
August 30, 2025 at 5:18 PM
Train and then tram to a location near the motorway 😁
Congratularions, Lino!
August 27, 2025 at 5:39 PM
Congratularions, Lino!
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 …