Oracle Magazine, May/June 2018
Database Developer PL SQL Working with JSON Arrays in PL SQL Use the PL SQL JSON_ ARRAY_ T object type to construct and manipulate in memory JSON arrays As explored in my last Oracle Magazine article Oracle Database 12c Release 2 adds several predefined object types to PL SQL to enable fine grained programmatic construction and manipulation of in memory JSON data You can introspect it modify it and serialize it back to textual JSON data You can use the new PL SQL object types to programmatically manipulate JSON data in memory to do things such as the following Check the structure types or values of existing JSON data Transform existing JSON data Create JSON data by using complex rules that reflect the kind of per row variation you can find in document oriented applications The PL SQL JSON object types available for use are JSON_ ELEMENT_ T JSON_ OBJECT_ T JSON_ ARRAY_ T and JSON_ SCALAR_ T This article explores the JSON_ ARRAY_ T type in more detail ORACLE MAGAZINE MAY JUNE 2018 62 ORACLE DATABASE By Steven Feuerstein
You must have JavaScript enabled to view digital editions.