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
.
Chapters
json_object
, json_array
, json_objectagg
, and json_arrayagg
are presented.