Submit Blog

Sign up Sign in

Search Articles

Filter by Tag

Sort By

Popular Tags

Filter Clause Articles

Page 1 of 1 (2 articles)

Emulating SQL FILTER with Oracle JSON Aggregate Functions

6/3/2024 • EN

Emulating SQL FILTER with Oracle JSON Aggregate Functions

Explains how to emulate SQL's FILTER clause for JSON aggregate functions in Oracle, addressing NULL value handling in JSON arrays and objects.

Aggregate Functions Filter Clause json oracle sql

2/6/2023 • EN

The Performance Impact of SQL’s FILTER Clause

Analyzes the performance difference between SQL's FILTER clause and CASE expressions in aggregate functions, using PostgreSQL benchmarks.

Aggregate Functions Filter Clause postgresql Query Optimization sql