JSON_SCALAR accepts a SQL scalar value as input and returns a corresponding JSON scalar value as a
JSON type instance. In particular, the value can be of an Oracle-specific JSON-language type, such as a date, which is not part of the JSON standard.
The argument to
JSON_SCALAR can be an instance of any of these SQL data types:
INTERVAL YEAR TO MONTH,
INTERVAL DAY TO SECOND,
JSON type instance is a JSON-language scalar value supported by Oracle.
You can use the
JSON_SCALAR function, only if the database initialization parameter
compatible is at least
20. Otherwise it raises an error.