Deep scan with oracle SQL/JSON

Question

Java Jayway jsonpath uses the operator .. to initiate a so-called deep scan (see here). Is there something similar in oracle SQL/JSON? I looked at the oracle documentation here but didn't find anything similar.

edit your question and add some sample data and the expected output based on that data. Formatted text please, no screen shots. Do not post code or additional information in comments — user330315
– user330315, Commented Sep 5, 2017 at 18:24
"A path is indefinite if it contains: .. - a deep scan operator". That tells me nothing about what the operator actually does so how are we meant to determine if Oracle has something similar? — MT0
– MT0, Commented Sep 5, 2017 at 18:43

Beda Hammerschmidt · Accepted Answer · 2017-09-07 02:44:19Z

1

Currently SQL/JSON path expressions do not allow what you call 'deep scans' (or // in XPath). Can you tell us more about the use case? Do you really need to recursively nested arbitrarily deep into the json or can you enumerate the possible paths? Thanks

answered Sep 7, 2017 at 2:44

Beda Hammerschmidt

4463 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

jeromerg Over a year ago

Thank you for the answer. I need to look for "error" keys in a kind of logging nested structure. The "error" keys can be at many places and at many depths in the tree. So it is quite hard to enumerate all the possible paths in advance.

Collectives™ on Stack Overflow

Deep scan with oracle SQL/JSON

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related