Dani Schnider

QUALIFY: The WHERE Condition for Analytic Functions Filtering analytic functions was not straight-forward in Oracle and most other databases. Oracle 26ai now supports the QUALIFY clause in SQL. It works like a WHERE condition, but can be used for an…

The QUALIFY clause enables you to filter rows using window functions

e.g. get the top ranked rows with

SELECT ... FROM ...
QUALIFY RANK () OVER ( ORDER BY ... ) = ...

@danischnider.bsky.social looks at how it works in Oracle AI Database 26ai

Oracle AI Database 26ai Enterprise Edition now GA for on-premises Linux x86-64 Oracle AI Database 26ai Enterprise Edition is now generally available for Linux x86-64. You can download it from the usual places, such as the Oracle Database download page, Software Delivery Cloud (eDelivery), and My Oracle Support (the RU). Check out the Oracle AI Database New Features Guide to see all the new features that came in this release. …

🎉 #Oracle #AI #Database 26ai Enterprise Edition is now generally available for Linux x86-64 on-prem!

What’s new for Developers in Oracle AI Database 23.26.0 For more information on what’s new in Oracle Database 23.9, see: What’s new for Developers in Oracle Database 23.9 Oracle AI Database 23.26.0 brings some fantastic new features to developers—again!…

Oracle AI Database 23.26.0 developer features include

QUALIFY clause
GraphQL Table Function for SQL
SQL Objects and Collections in MLE JavaScript
PL/SQL RESETTABLE clause to avoid ORA-04068: existing state of packages has been discarded

@gvenzl.bsky.social

On the way home from #DOAG2025: We were too careful with the expected delay of Deutsche Bahn. So we habe 75 minutes to change in Munich. Time for a beer 😊

Data Types of Join Columns The data type of primary key and foreign key columns has an impact on the query performance. This should be considered in the design decision of keys in a Data Vault schema.

How do the data types of join columns affect query performance?

@danischnider.bsky.social compares using

Hashes as CHAR(32) and RAW(16)
Sequences as NUMBER

And finds in Oracle #SQL

NUMBER is faster than RAW
RAW is faster than CHAR

Full room at the „Fun with SQL“ session of @andreakennel.bsky.social at #DOAG2025

If you love your data then you have to love this feature. Presented by @toonkoppelaars.bsky.social who joined Oracle to make that happen. #DOAG2025

SQL assertions syntax

Multi row/multi constraint example “controllers must work in finance”

Multi row/multi table constraints “Can’t earn more than your manager” “Can’t have multiple presidents” “Must be a president”

Coming in Oracle AI Database

#SQL assertions

These enable you to create cross row, cross table constraints with SQL standard syntax

CREATE ASSERTION … CHECK (
[ NOT ] EXISTS ( <query> )
)

@toonkoppelaars.bsky.social explains at #DOAG2025

Learning from mistakes is important. Better: learn from others' mistakes. Even better: today we can learn from @danischnider.bsky.social 's ones #doag2025

🎤 Don’t miss DOAG Konferenz + Ausstellung 2025 — Nov 18–21, the premier event for database technologies in the German-speaking region!

Join #OracleACE experts and industry leaders for in-depth sessions on Oracle tech, modern IT trends, open source, and more. 👉 anwenderkonferenz.doag.org/de/home/

QUALIFY: The WHERE Condition for Analytic Functions Filtering analytic functions was not straight-forward in Oracle and most other databases. Oracle 26ai now supports the QUALIFY clause in SQL. It works like a WHERE condition, but can be used for an…

Since last week, I can finally use the QUALIFY clause in Oracle. If you never heard of this SQL extension, read my newest blog post:

danischnider.wordpress.com/2025/10/24/q...

Exciting to see Oracle ACEs featured as speakers at SOUG Day Zurich 2025 on October 23! 🇨🇭✨ Get ready for a day full of expert insights and networking with the Swiss Oracle community.

Discover more:
🔗 soug.ch/event/soug-day-zurich-2025/

@helifromfinland.bsky.social @danischnider.bsky.social

A funny last session at #HrOUG2025 with SELECT AI Funhouse and @kibeha.dk

Last day at #HrOUG2025 starts with @salvis.com fighting with bad code

Fundamentals of Oracle security (and some drinks) with @chandlerdba.bsky.social at #HrOUG2025

Basic knowhow that every Oracle developer and DBA should know: how do transactions work in an Oracle database. @martinklierdba.bsky.social explains it in detail at #HrOUG2025

This is how a latch contention looks in real life. The @ora600pl.bsky.social way at #HrOUG2025

The slides were generated by ChatGPT - @ora600pl.bsky.social switches back to his traditional presentation style with beer and live demos

So many slides on a session of @ora600pl.bsky.social ? Something must be wrong here. Let‘s see…
#HrOUG2025

Hopefully not, otherwise beginners like me would be lost

After lunch break session at #HrOUG2025 about CI/CD using #SQLcl, presented by @apexconsulting.nl (with a very nice t-shirt, by the way)

If you are at #HrOUG2025 and don‘t speak Croatian, you are probibly interested in this additional session tomorrow

Quiet moment during the #HrOUG2025 conference

Lot if interest in deep diving into performance of views by @danischnider.bsky.social at #HrOUG2025

#HrOUG2025
@fsarcos.bsky.social talks about dragons and PDB failover approaches in Oracle 23ai (aka 26ai)

I still like this session of chandlerdba.bsky.social about Exadata alternatives and why Exadata is still the cheapest and best solution.
Once again at #HrOUG2025

Looking forward the the 30th anniversary of a wonderful conference

#HrOUG2025

Almost there… #HrOUG2025

Just arrived in Rovinj in time thanks to the professional „Grisselbav Tours“ driver @salvis.com with co-pilot @andreakennel.bsky.social

@danischnider.bsky.social erzählt uns in einem Kurz-Interview von seiner großen Begeisterung für die #DOAG2025 in Nürnberg. ➡️ scomp.ly/jPg3bBb

Die Anwenderkonferenz
📍DOAG 2025 Konferenz + Ausstellung | Nürnberg Convention Center
📅 18.–21. November 2025

🔗Anmeldung | scomp.ly/YAj48bE

Datenbankpannen made in Switzerland: Von DropTable bis Split-Brain – Teil 2 unserer DOAGtv-Geschichten mit Martin Klier, @stefanoehrli.bsky.social und @danischnider.bsky.social zeigt, wie Recovery-Nächte auch mal mit Pizza enden ➡️ scomp.ly/Y3DVQmY