JSON Data Type in Oracle Database 21c

In this video we'll demonstrate the JSON data type, introduced in Oracle database 21c.

Cameo by Maria Colgan :

Cameo appearances are for fun, not an endorsement of the content of this video.

All trademarks, product names and logos are the property of their respective owners.

#oracle #JSON #datatype

[bmmr]

Thanks for this great video, this query might help someone in future

Cursor C1 IS
select to_char(c.clob001) cb, json_value(c.clob001, '$.transcriptions.transcription') as transcriptions from apex_collections c
where c.collection_name = 'REST_COLLECTION';