Login
From:
Java, SQL and jOOQ.
(Uncensored)
subscribe
How to implement FILTER semantics with Oracle JSON aggregate functions
https://blog.jooq.org/emulating-sql-filter-with-oracle-json-aggregate-functions/
links
backlinks
Tagged with:
json
sql
filter
json arrayagg
aggregate functions
filter clause
json aggregate functions
json objectagg
Oracle 23ai still doesn't support the standard SQL FILTER clause on aggregate functions, which can prove to be tricky to emulate on JSON aggregate functions
Roast topics
Find topics
Find it!
