Remember SQLcl’s SCRIPT command? Why did it disappear from modern environments, and how can we bring it back? Both in standalone SQLcl and in the SQLcl embedded in SQL Developer for VS Code? www.salvis.com/blog/2026/07...

The Return of SQLcl’s SCRIPT Command

Introduction The script command was introduced with SQLcl 4.2. It is based on JSR 223, the Java Scripting API, and makes it possible to run JavaScript from SQLcl. This adds client-side control flow, f...

salvis.com

There’s static SQL and dynamic SQL, but in between there’s also SQL that’s “dynamic at parse-time,” known as polymorphic (meaning it can change “shape”.) This talk, run by @kibeha.dk, looks at different ways to achieve this. #POUG2026 last 11 tickets: poug.org/edycja/poug2...

So, nested with? Sure, thanks I guess. Multi-nested with? Yeah. Whatever. Wait, what's this, almost as a side note? Using macros in a with clause? Yes! Finally! Yesterday please! And backport to 19c please. Did I say please yet? Please!

Connor McDonald on Database and SQL@connormcd.bsky.social · last mo.

With the new WITH WITH, you can do more WITH every WITH than you ever did WITH WITHout WITH ... or something like that :-) connor-mcdonald.com/2026/07/01/w...

Friday thoughts ... Stop writing code from your "happy place" :-) connor-mcdonald.com/2026/06/26/b...

Blue Sky Programming – The Optimism Trap

Many years ago, before I joined Oracle, I was working on a major modernisation project. We were replacing an existing non-Oracle system with an entirely new Oracle database application written from…

connor-mcdonald.com

Can syntax diagrams be generated from the APEXlang EBNF grammar? Yes! This post shows the conversion to W3C EBNF, the tooling used, and the resulting railroad diagrams. www.salvis.com/blog/2026/06...

Syntax Diagrams for APEXlang

Introduction The APEXlang API Reference documentation went live a few days ago. You can also download the APEXlang EBNF grammar. In this post, Kris Rice explains the value of having an EBNF. Since the...

salvis.com

Mrs W (MIll House Millinery) has a pop-up shop in Newmarket, 24th June - 10 July. She is running workshops where you make your own fascinator, showing and selling her hats & fascinators, and will be delighted to talk to you about the talks & workshops she does! www.facebook.com/reel/8370715...

Welcome to #POUG2026! The fridge is full of beers. Help yourself and take as many as you like. But there’s one sacred rule: one beer must always remain. The beers & @franckpachot.bsky.social will be in Krakow on September 4-5th, but will you? www.poug.org

Next for me at #MakeIT2026 is a Kim Berg Hansen-Lab 😁 @kibeha.dk @sym42.bsky.social @oracleace.bsky.social

First session I attend at #MakeIT2026 By @kibeha.dk The start of a couple of exiting days

My first visit to Slovenia, I'm excited to be a speaker at SIOUG MakeIT 2026! I'm on twice tomorrow: - Visualizing PL/SQL with PL/Scope, 26ai Property Graph and APEX Graph Plug-in - 3-hour Hands-On-Lab on analytic functions. Check it out: makeit.si #MakeIT2026 #OracleDB #OracleAPEX #OracleACE

Next week: @oraesque.bsky.social “utPLSQL – The Perfect Testing Tool for Lazy People”. While waiting, check out my interview with veteran Mariusz Masewicz on avoiding weekend debugging: [https://how2ora-en.blogspot.com/2026/05/interview-with-mariusz-masewicz-man-who.html] 🎙️ Don't miss it!

My venue this afternoon. Come join my session at 3PM on 26ai assertions new feature. #apexconn26

(re)connect doorbell to phone... -Open App -Hit the + -Select doorbell -Select wifi -Scan this QR code... (no alternatives) Really? This was designed, built, tested (how?) and released without anybody thinking "wait a minute?" Don't worry I'll work around it, but not everybody will. Idiots.

Drake's Disappointed Shrug

ALT: Drake's Disappointed Shrug

static.klipy.com

Another great webinar from #POUG x #PWOW comin up. The one and only @oraesque.bsky.social will tell you all you need to know to turn unit testing from a time consuming job that keeps you from developing into a click of a button. May 27 at 20:00 CEST pwowwebinar3.konfeo.com/en/groups

Add this to all the other reasons why you really should c9mento Krakow in September, and I really don't understand why you didn't get a ticket yet 🫤

Polish Oracle User Group@pougorg.bsky.social · 3mo ago

@rogermacnicol.bsky.social + one last encore = storage fireworks! 🎆 "Intelligent storage, a 20 year retrospective" at #POUG2026. Oracle legend, legendary stories, legendary send-off. Don’t miss the final chapter. 💾🔥 Tickets: poug.org/edycja/poug2...

Another quarter Another batch of new Oracle #SQL features in the 23.26.2 RU 😀 See the complete list at docs.oracle.com/en/database/... Here are some of the highlights - which are your favourites?

New version of utPLSQL \o/ www.linkedin.com/posts/jacek-...

#utplsql #oracle #pl_sql #testing #opensource #java #databasetesting | Jacek Gebal

🚀 The utPLSQL project just got a refresh! We're happy to announce a new set of releases across the utPLSQL ecosystem: 📦 utPLSQL framework v3.2.01 📦 utPLSQL-java-api v3.2.4 📦 utPLSQL-cli v3.2.0 📦 utP...

linkedin.com

It's official, our Skills for Oracle AI Database github.com/oracle/skills Get started, simply: npx skills add oracle/skills

GitHub - oracle/skills: Oracle DB Skills is a curated library of 100+ practical, documentation-backed guides for working with Oracle Database, organized by domain

Oracle DB Skills is a curated library of 100+ practical, documentation-backed guides for working with Oracle Database, organized by domain - oracle/skills

github.com

New bugfixing method: Fix-by-typo

mike tyson laughs while sitting in front of a comedy central logo

ALT: mike tyson laughs while sitting in front of a comedy central logo

media.tenor.com

Piet de Visser@pdevisser.bsky.social · 3mo ago

Fixed by AI: Custom software stopped throwing errors in the category "Exception"... AI-supported developers laughing their heads off: The silly human had a query : reason like 'Exception%'. Hence Easy to eliminate those Errors...

There seems to be a school of thought in the tech community that a robust knowledge SQL is now optional. My thoughts are that the exact opposite is true: Learning SQL is more important than ever. connor-mcdonald.com/2026/04/22/s...

SQL skills just got MORE important

There seems to be a school of thought in the tech community that a robust knowledge SQL is now optional. After all, with modern AI tools able to generate SQL from plain English, it seems “obv…

connor-mcdonald.com

Good point by Connor to add tiebreakers to the order by clause. I will add: do NOT use default RANGE BETWEEN but please explicitly use ROWS BETWEEN ! www.kibeha.dk/2013/02/rows...

Connor McDonald on Database and SQL@connormcd.bsky.social · 4mo ago

Blog greatest hits :-) . Why does SUM look broken for window functions?. https://connor-mcdonald.com/2021/04/27/why-does-sum-look-broken-for-window-functions/

Get Oracle Partition High Values as VARCHAR2 types instead of LONG in Oracle 19c and earlier (new blog). There's also some data 23/26ai data dictionary internals! tanelpoder.com/posts/oracle...

When you feel insulted, but don't have very strong counter arguments 😢

Connor McDonald on Database and SQL@connormcd.bsky.social · 4mo ago

I must admit, doing a data quality talk at a developer conference feels a little like heading into the lions den 🦁😂 #VDZ26

Assertions for data integrity on a less-than-ideal data model. www.kibeha.dk/2026/03/asse... Or "How I could have used assertions 25 years ago when I worked with Concorde XAL"... #OrclDB #SQL #Assertions #OracleACE

Assertions for data integrity on a less-than-ideal data model

25-30 years ago I worked a lot with the Danish developed ERP system called Concorde XAL. It ran on top of a database (choice of several, mos...

kibeha.dk

😮

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺@kibeha.dk · 5mo ago

TIL in 23/26ai with extended strings, you do NOT get "ORA-01450: maximum key length (6398) exceeded" at *create* index on VARCHAR2(4000 CHAR) - it succeeds => dba_ind_columns.column_length=16000 At *insert* you can get ORA-01450 ! blogs.oracle.com/sql/how-to-f... Careful or #BugWaitingToHappen

📣 26ai is now available for download, x86-64 bit Linux distributions. www.oracle.com/database/tec...

www.youtube.com/watch?v=dNvI...

Cross table constraints with SQL assertions

YouTube video by Oracle Developers

youtube.com

Finally...

Chris Saxon@chrisrsaxon.bsky.social · 6mo ago

Assertions Define cross-row, cross-table constraints with simple SQL: CREATE ASSERTION ... CHECK ( <rule> ) Use this to enforce rules like * No overlapping start-end dates * Every parent row must have a child row (invoices must have an invoice line)

It's here at last! Oracle AI Database 26ai (23.26.1) Enterprise Edition for Linux x86-64 on premises is GA Once again, there's a host of #SQL updates in this RU. Here are a few to get you started:

I can hardly wait to get my hands on this.....

Connor McDonald on Database and SQL@connormcd.bsky.social · 7mo ago

OMG ... I can't believe it. It is really gonna happen! #ComingSoon