Could not get expected output using JSON_TABLE

Jun 4, 2020 10:58AM

I have a following json expression which is a response of an HTTPS call:

[{"result":{"Response":{"id":"132844","execStatus":"200","execDescription":"SUCCESS"}}}]

I want to extract value of id element which is 132844.

I used following query but did not get expected output.

(select id

from json_table('[{"result":{"Response":{"id":"132844","execStatus":"200","execDescription":"SUCCESS"}}}]', '$[*]'

columns id varchar2(500) path '$."id"'));

I am using DB version 12.1.0.2.0

I also checked below document:

SQL Language (MOSC)