JSON

Thumbnail image for Crop a CLOB with DBMS_LOB.FRAGMENT_DELETE

Crop a CLOB with DBMS_LOB.FRAGMENT_DELETE

How to delete fragments from a CLOB, from either end, using the procedure DBMS_LOB.FRAGMENT_DELETE in Oracle.

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 CLOB data , 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 →