Part V Generation of JSON Data
You can use SQL to generate JSON data from other kinds of database data programmatically, using SQL/JSON functions json_object, json_array, json_objectagg, and json_arrayagg.
- Generation of JSON Data with SQL/JSON Functions
SQL/JSON functionsjson_object,json_array,json_objectagg, andjson_arrayaggare presented.