13.6 Oracle Implementation of Semistructured Data

Oracle supports both JSON and XML data, being able to accept documents in either format, allowing documents in both formats to be stored in Oracle databases, and producing output in either format from Oracle databases.

13.6.1 JSON in Oracle

Oracle supports JSON in relational databases, extending the traditional relational capabilities of using SQL. Oracle provides access to JSON data using several Simple Oracle Document Access (SODA) APIs. These APIs allow applications to create, store, and access JSON data in a schemaless fashion, without specifying how the documents are structured or stored in the database, and without using SQL. Current SODA implementations include SODA for Java, Python, ...

Get Databases Illuminated, 4th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.