It's never been easier to convert SQL queries into JSON documents | ORA-00937 and ORA-40478

Description:
In this final part of our JSON series, we complete the complex JSON document and solve the most common errors you'll encounter: ORA-00937 and ORA-40478. Learn how to properly sort the elements inside a JSON_ARRAYAGG and handle large JSON outputs that exceed the 4000-character limit.

???? What you'll learn in this video:
✅ How to fix the ORA-00937 "not a single-group group function" error using a CTE.
✅ The correct way to sort a JSON array by a specific field (like order_id) using ORDER BY inside JSON_ARRAYAGG.
✅ How to resolve the ORA-40478 error by using the RETURNING CLOB clause for large JSON documents.

This tutorial is essential for anyone working with JSON in Oracle Database, especially for generating complex, well-formatted API responses or data exports.

00:00:00 ORA-00937 "not a single-group group function" error using a CTE.
00:01:19 Sorting a JSON array by a specific field
00:02:29 Notes version 12c and 18c
00:02:57 ORA-40478 error by using the RETURNING CLOB clause for large JSON