Given JSON:
j json_object_t := new json_object_t(
q'[{"Wabbit":{"BugsBunny":{"action":"eat a carrot","statement":"Ehh..? What's up Doc?"}}}]' );
How do I check that the node $.Wabbit.BugsBunny.action exists within PL/SQL?
I am trying to avoid converting it to a CLOB and use JSON_TABLE() or JSON_EXISTS
I tried j.has('Wabbit.BugsBunny.action') but that didn't work.
Do I have to recursively fetch and check each node in a loop? ( j.has('Wabbit') returns TRUE as expected )
Database: 21c ATP Free Tier
Thanks,
MK