HomeОбразованиеRelated VideosMore From: ODTUG

CodeTalk Series: JSON in the Oracle Database

5 ratings | 669 views
Steven Feuerstein, Oracle Corporation Darryl Hurley, Implestrat.com Did you know that Oracle Database 12c makes it easy for you to store, manipulate, and serve up JSON documents? You certainly do NOT need to install a document store database side-by-side with Oracle Database when your UI developers start demanding JSON! Join Steven Feuerstein for an interview with and demonstrations by Darryl Hurley of Implestrat.com. Darryl, an active database developer and DBA for many years, has lately been diving into the JSON features of 12.1 and 12.2. Make sure you are positioned to have a smart conversation with the JavaScript developers in your company about how you can help meet their JSON needs.
Html code for embedding videos on your blog
Text Comments (4)
Marcelo Carrasco (1 month ago)
Hi, Can you provide the scripts you used in the video? Thanks.
Abhishek Sant (5 months ago)
JSON_Object_AGG dont work with the large data in the table :( Maximum 4000
Abhishek Sant (5 months ago)
Hi, In Array it we want to find all the elements in query is it possible? SELECT JSON_VALUE('{a:[5, 10, 15, 20]}', '$.a[0]') AS value FROM DUAL;-- this will return and will return 5 SELECT JSON_VALUE('{a:[5, 10, 15, 20]}', '$.a[*]') AS value FROM DUAL;-- this will return null if requirement is to return all element in the array is it possible 5,10,15,20
Abhishek Sant (5 months ago)
Hi ,In Dot notation ,Do we have the same functionality eg: select all the Key values just like "select * from table_name"?

Would you like to comment?

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