Part III Insert, Update, and Load JSON Data
The usual ways to insert, update, and load data in Oracle Database work with JSON data. You can also create an external table from the content of a JSON dump file.
- Overview of Inserting, Updating, and Loading JSON Data
You can use database APIs to insert or modify JSON data in Oracle Database. You can use Oracle SQL functionjson_transform
orjson_mergepatch
to update a JSON document. You can work directly with JSON data contained in file-system files by creating an external table that exposes it to the database. - Oracle SQL Function JSON_TRANSFORM
Oracle SQL functionjson_transform
modifies JSON documents. You specify modification operations to perform and SQL/JSON path expressions that target the places to modify. The operations are applied to the input data in the order specified: each operation acts on the result of applying all of the preceding operations. - Oracle SQL Function JSON_MERGEPATCH
You can use Oracle SQL functionjson_mergepatch
to update specific portions of a JSON document. You pass it a JSON Merge Patch document, which specifies the changes to make to a specified JSON document. JSON Merge Patch is an IETF standard. - Loading External JSON Data
You can create a database table of JSON data from the content of a JSON dump file.