HomeНаука и техникаRelated VideosMore From: Dominic Giles

JSON In the Oracle Database 12c Release 1 (12.1.0.2)

21 ratings | 8101 views
A really quick look at the ability to store JSON in the Oracle Database 12c Release 1 (12.1.0.2) and accessing it using Python and the Oracle_CX open source driver. You can find the Oracle documentation on it here http://docs.oracle.com/database/121/ADXDB/json.htm#ADXDB6246
Html code for embedding videos on your blog
Text Comments (9)
James Roman (2 years ago)
Starting with ODI 12c, you can use JSON as a data source. The following OTN article provides a detailed example: https://community.oracle.com/docs/DOC-1005678
Pretty Printed (3 years ago)
Nice overview. Thanks!
Humberto Arechiga (3 years ago)
Very Nice, thanks alot. I'm trying to use the same structure as you and want to select all the mobile number only. Can the following be done some how? SELECT C.DATA_INFO.NAME_LAST, C.DATA_INFO.PHONES.NUMBER FROM CUSTOMER C WHERE C.DATA_INFO.PHONES.TYPE = 'mobile';
John Fisher (3 years ago)
This looks like great stuff. But... can you update JSON data without updating the entire field? When I try that I get an "unimplemented feature" error. For example, if po_doc is a JSON database field, with an existing value for PONumber, I want to be able to update just one field: update purchase_order po set po.po_doc.PONumber = 2100 where po.po_doc.PONumber = 2000; Is this possible? Our JSON structures are very large, and we really need to be able to do partial updates.
Dominic Giles (1 year ago)
It's coming, and at some stage will remade available in SODA APIs for REST and Java completely transparently. Obviously that's not me guaranteeing it... Safe Harbour and all that. But unless you have huge JSON documents it shouldn't make a significant difference. Oracle's logging engine is incredibly efficient. Maybe I'll release a video showing the difference...
Ashokkumar Murugesan (1 year ago)
Any idea when this will be available? I guess we have to use PL/SQL code to do part updates now. But it will be better if API is provided.
Dominic Giles (3 years ago)
+John Fisher great question. And at present no. You update the entire Varchar/BLOB structure.
Martins (3 years ago)
Good work
Liguo Kong (4 years ago)
very nice. Thx.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.