Querying JSON Objects Using Path Expressions in Oracle 12C

Having trouble building your Python app? I can help:

This video demonstrates how to use JSON path expressions to query JSON objects in Oracle 12C.

[MicahDanielSmith]

For anyone who is following this in the future and doesnt want to type out that insert statement:
insert into json_path_example values (1,
'{"name":"Wildcats",
"coach":"Joe Armin",
"players":[{"name":"Eric", "number":55, "position":"center"},
{"name":"Anthony", "number":12, "position":"shooting guard"},
{"name":"Rodney", "position":"point guard", "number":22}],
"games": [{"opponent":"Bulldogs", "location":"home", "points-for": 192, "points-against": 35,
"player-points":[{"name":"Eric", "points":102},
{"name":"Anthony", "points":50},
{"name":"Rodney", "points":40}]},
{"opponent":"Falcons", "location":"away", "points-for": 21, "points-against": 3232,
"player-points":[{"name":"Eric", "points":2},
{"name":"Anthony", "points":8},
{"name":"Rodney", "points":11}]}]}');

[mohan]

Thanks very much for the wonderful articles on JSON, it is very useful to understand JSON implementation in Oracle.