JSON Data in Oracle

 JSON Data in Oracle

Oracle Database includes support for storing and querying JSON (JavaScript Object Notation) data, which is a lightweight data format that is commonly used for web applications and APIs. Here is an example:

CREATE TABLE books (

   book_id NUMBER(10),

   book_title VARCHAR2(100),

   book_data CLOB CONSTRAINT ensure_json CHECK (book_data IS JSON)

);

INSERT INTO books (book_id, book_title, book_data)

VALUES (1, 'The Catcher in the Rye', '{"author": "J.D. Salinger", "year": 1951}');

This creates a table named "books" with a column named "book_data" that is constrained to store only JSON data. The INSERT statement inserts a JSON object into the table.

In-Memory Column Store