Showing posts with label Aggregation Filter. Show all posts
Showing posts with label Aggregation Filter. Show all posts

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.