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";