JSON_SCALAR
Purpose
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: BINARY_DOUBLE
, BINARY_FLOAT
, BLOB
, CLOB
, DATE
, INTERVAL YEAR TO MONTH
, INTERVAL DAY TO SECOND
, JSON
, NUMBER
, RAW
, TIMESTAMP
, VARCHAR
, VARCHAR2
, or VECTOR
.
The returned 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.
See Also:
See Oracle SQL Function JSON_SCALAR of the JSON Developer's Guide.