JSON_TABLE

Referred from Oracle Standard Document

Data retrievable / parsing using JSON_TABLE

SELECT jt.*
  FROM 
       json_table('JSON STRING', 
         '$'
         COLUMNS (
           "COLUMN_NAME" VARCHAR2(4000) PATH '$.JSON_KEY'
           ....
           ....
           ,
           NESTED PATH '$.nested_array[*]'
             COLUMNS (
               COL01  NUMBER        PATH '$.COL01_PATH',
               COL02 VARCHAR(4000) PATH '$.COL02_PATH'
               ...
               ...
               ))) AS "JT";