Creating Tables with JSON Columns

You can create a table that has one or more JSON columns, alone or with relational columns. You must use JSON data type for the JSON columns.

JSON type columns have these restrictions:

• Do not support column-level constraints.

• Do not support column-level compression.

• Cannot be a join column.

• Do not generate statistics.

Also, JSON documents cannot be partially updated in a JSON type column. See Inserting and Updating JSON Data.

See also:

CREATE TABLE in Oracle TimesTen In-Memory Database SQL Reference

Example 2-1 Creating a Table with a JSON Type Column

This example creates j_purchaseorder table with the JSON data type column, po_document.

CREATE TABLE j_purchaseorder (
  id          VARCHAR2 (32) NOT NULL PRIMARY KEY,
  date_loaded TIMESTAMP (6),
  po_document JSON);