Greetings
On 19c
I am creating views on JSON objects and am struggling to figure out how I can extract the value of key-value pair inside an array when the specific key that I need could be anywhere in the array.
Attached is a file containing 2 JSON objects.
Inside the array is a field called "ga_session_id" which could be in any position of the array.
I want to extract that field always. The SQL should return 2 rows, with a populated ga_session_id key as a column.
Any help would be greatly appreciated!
data.txt (1000 Bytes)