JSON

Passing JSON PL/SQL types to MLE JavaScript

Recently the MLE team was asked if it was possible to pass JSON PL/SQL types to…
Why does my call to json_table return null for a column despite it not being empty?

I recently worked on a fun project involving JSON and Oracle Database 23ai. I had to…
Using Oracle Database 23ai as a Document Store

JSON is one of the most popular data formats, and unsurprisingly, modern, multi-model database, Oracle included,…
NJS-044: named JSON object is not expected in this context in MLE/JavaScript

This is a quick post hopefully saving you 5 minutes debugging the following error in Multilingual…
JSON strict and lax syntax in Oracle Database | Pt 3: Type Conversions (SQL functions)

A recent forum post prompted me to look into JSON syntax rules and their implications more…
JSON strict and lax syntax in Oracle Database | Pt 2: Type Conversions (dot notation)

A recent forum post prompted me to look into JSON syntax rules and their implications more…
JSON strict and lax syntax in Oracle Database | Pt 1: Storing JSON

A recent forum post prompted me to look into JSON syntax rules and their implications more…
With-clause, values operator and a strange JSON_TABLE error

A short tale of investigating a problem with JSON_TABLE, common table expressions and the value operator…
MLE type mapping: passing JSON to JavaScript functions in Oracle Database 23c
JSON support in Exadata 12.1.2.1.0 and later

Some time ago Oracle announced that RDBMS 12.1.0.2 has built-in support for JSON processing. A little…