How do I access the elements of TaskArray?
with q as (
select '[
{
"ID": 9801,
"ComponentID": null,
"Component": null,
"OrderNumber": 1172,
"GroupID": 3,
"SubmittedDate": "10/03/2020 10:01",
"ValidationStatus": "Approved",
"TaskArray": "[{\"Stage\":\"Shelf\",\"TaskID\":\"9\",\"TaskName\":\"Build Virtual Server\",\"TaskTeam\":\"OSOS\"}]"}]' doc
from dual)
select a.*
from q,
json_table(q.doc, '$[*]'
columns
identifier number path '$.ID',
task_array clob path '$.TaskArray',
nested '$.TaskArray'
columns (
stage varchar2(250) path '$.Stage')) a
/
IDENTIFIER TASK_ARRAY STAGE
---------- ------------------------------------------------------------ ----------
9801 [{"Stage":"Shelf","TaskID":"9","TaskName":"Build Virtual Ser
1 row selected.