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!

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.

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

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

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

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.

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.

📢 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

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

I just noticed the 23.8 version of 23ai Free has a different file name to previous versions. It now includes the version number. Nice! www.oracle.com/uk/database/... @OracleDatabase #oracle #database

Scripting in SQLcl with @evrocs.bsky.social and many cats at #itougtd2025

And we're about to start #ITOUG #TechDay2025

We’re thrilled to welcome #MySQL as a partner of #POUG2025! 🎉 POUG turns 10, MySQL turns 30 - coincidence? Sounds more like a destiny for us.😎 🎟️ Join the epic celebration: poug.org

Saying goodbye to my beautiful neighbors in Rust, Germany to drive from #APEXconn25 to Milan for #ITOUG25 with a short stop to have a coffee with dear friend @julianfrey.ch in Switserland. Life could be worse.

Oracle Database Free 23.8 is now available Get it at www.oracle.com/database/fre... This has a neat tweak if you're getting poor row estimates for PL/SQL in SQL: Enhanced dynamic stats for PL/SQL in FROM & WHERE This can be particularly useful for estimating pipelined table functions

The mix of technical knowledge, an engaged audience, and a non-formal atmosphere. Only at #POUG2025! Listen to @martinwidlake.bsky.social advice and join us in September: poug.org/edycja/poug-...

The introduction of the APEX song at #APEXconn25 😂

Kickoff of the 11th #APEXconnect by @nielsdb.bsky.social We're having three great days ahead of us

Celebrating speaking at POUG this year with a local beverage :-)

Woke up to some awesome news…I’ll be speaking at #POUG2025 for the first time!

Together with @chrisrsaxon.bsky.social , I'm speaking at #POUG2025 We're doing a double-length symposium session on SQL macros, functions and how the transpiler can help. See all of the agenda: poug.org/edycja/poug-... Get your tickets: poug2025.konfeo.com We'll meet in Poznan.

This September. Don't have FOMO! The @pougorg.bsky.social 10th anniversary conference. the best line up of Oracle speakers you'll ever find having fun and learning Want your systems to be better? Be there Want to have fun? Be there check it out! poug.org/edycja/poug-... #POUG2025 #POUGaholic

New post! How to execute a script against multiple @OracleDatabase concurrently using SQLcl. www.thatjeffsmith.com/archive/2025...

The One you dont want to miss. I'm a #POUGaholic , and I'm OK with that. @ora600pl.bsky.social @luizafrompoland.bsky.social #POUG2025

Arrived at my appartment in Rust, Southern Germany for #ApexConnect 2025 that'll start Tuesday. Across the street is a stork couple. But trust me I'm not planning on creating any more offspring.

Got your tickets yet?

It's time to break the silence. #POUG2025 is not just a fun conference. It can be dangerous. @Erik Van Roon was the first to speak loudly about the consequences of attending our event. ...but if you have no fear, cheaper tickets are still available: poug.org/edycja/poug-... 😎

Want to exclude columns from SELECT * statements in Oracle #SQL? From 19.7, you can do this by creating a SQL macro which Accepts a table and an exclusion column list Loop through the table's columns Add the columns not in the exclusion list to the select

Best fix/feature in #Oracle SQLcl 25.1.0 : When you change the contents of a file (e.g. a package body), "project stage" will automatically reformat the code and update the hash. No need to export it from the database again! #sqlcl #cicd #orclapex

Vergiss langweilige Konferenzen mit Verkaufsmaschen und null Mehrwert 🙄 Komm zu einem 100 % Tech-Event direkt hinter der Grenze - und werde Teil einer einzigartigen Community. #POUG2025 wartet im September auf dich! 🔥 poug.org/en/

On our way to Valencia for a, no doubt, wonderful weekend of sun, food, drinks and activities with @sym42.bsky.social

That pretty much seals it, my goal to visit as many US national parks as possible will be on hold for the forseable future. Even when having all valid documents, but having regime critial social media posts is enough to end up in jail youtu.be/nbwuaw5_hrg?...

#APEXWorld25 by @nloug.bsky.social One of the wonderful events that values new speakers and thus actively advertises for the MASH Program mashprogram.wordpress.com Thanks guys!

Friday is the day...

The (near) future of data integrity in the Oracle database is looking beautiful thanks to @toonkoppelaars.bsky.social and his team.

Can't make it to Copenhagen on May 7th? How about Helsinki May 5th: www.meetup.com/apex-meetup-... Or Stockholm May 9th: www.meetup.com/stockholm-or... No excuses - the #orclAPEX Nordic Tour is coming to you 👍

If the dean of one of the country’s top journalism schools is advising students to self-censor because “nobody can protect you,” then we have already passed a major milestone on the road to authoritarianism. www.nytimes.com/2025/03/12/n...

SQLcl 24.4.3 was released today and fixes the APEX export bug. Thanks for the heads up, Roel. #sqlcl #orclapex