Thursday, February 12, 2026

Aggregation Filter in Oracle AI 26 ai

 

This post is quick one!

Aggregation filter is a neat addition to the SQL in Oracle AI 26ai ( 23.26.1)

This feature makes SQL concise , easier to read. 

Looks different . Probably , I have to get used to it . :-) . I welcome your thoughts on this feature.


Here is an example.  












Here is the newer syntax. 






Here is the equivalent syntax that we used to use in pre-26 releases of Oracle.