JSON

Thumbnail image for JSON_TABLE Options: Error Handling, Nested Path

JSON_TABLE Options: Error Handling, Nested Path

Options that can be used with JSON_TABLE query operator to select JSON data as relational rows and columns: ERROR ON ERROR, FOR ORDINALITY, NESTED PATH etc.

Read the Full Article →
Thumbnail image for Extract Very Long String or CLOB from JSON [pre 12.2]

Extract Very Long String or CLOB from JSON [pre 12.2]

How to extract a very long string or CLOB from JSON , where the size to be extracted exceeds MAX_STRING_SIZE (32767), in a pre-12.2 Oracle database.

Read the Full Article →
Convert Relational Data to JSON

Convert Relational Data to JSON in Oracle: PL/JSON Method

How to convert relational data to JSON in the Oracle database, using PL/JSON.

Read the Full Article →
Thumbnail image for JSON Conditionals: JSON_EXISTS, JSON_TEXTCONTAINS

JSON Conditionals: JSON_EXISTS, JSON_TEXTCONTAINS

Implement true/false tests on JSON documents in Oracle database 12c using JSON conditional logic: JSON_EXISTS and JSON_TEXTCONTAINS.

Read the Full Article →
Thumbnail image for Querying JSON Data in Oracle: SQL/JSON Query Functions, Dot Notation

Querying JSON Data in Oracle: SQL/JSON Query Functions, Dot Notation

Querying JSON data in Oracle 12c using various query approaches: simple SQL, SQL/JSON functions (JSON_QUERY, JSON_VALUE, JSON_TABLE), dot-notation syntax.

Read the Full Article →
JSON in the database

Storing JSON Data in Oracle: Why and How

Storing JSON data in Oracle has been made easy in version 12c. A demo of how JSON can be stored in Oracle and validated using the IS JSON check.

Read the Full Article →