Please ready my latest #APEXShort to learn (by example) how to Parse JSON using Oracle SQL & PL/SQL  #orclAPEX #PLSQL #SQL 
https://blog.cloudnueva.com/json-parsing-by-example