CodeTalk Series: JSON in the Oracle Database

[@abhi1302]

Hi ,In Dot notation ,Do we have the same functionality eg: select all the Key values just like "select * from table_name"?

[@subbaraodasari593]

Is it possible to get the script you had run in sql developer during demo

[@LAMERFENER]

Thanks mate you literally saved my hours.

[@struggler762]

Really helpful 👍

[@goldenbutter07]

could you please share the script in description or in some fiddle?

[@aaqibrajput4482]

How can we post this data to a web api?

[@abhi1302]

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

[@marceloacarrasco]

Hi, Can you provide the scripts you used in the video? Thanks.

[@gaminglegends5191]

is there anyway to do this in oracle 10G?

[@DenisOjok]

:)

[@abhi1302]

JSON_Object_AGG dont work with the large data in the table :( Maximum 4000

[@shirinbehnam1473]

Perfect the so mush

[@surendrakumar2428]

HELLO PLESE EXPLAIN JSON OBJECT PASS JAVA END AND HANDLE ORACLE