JSON_TABLE Nested Path - Empty result

[Former Member]

Hello,

I am facing a Empty result in JSON_TABLE when the NESTED_PATH returns empty and need to handle the Nested path with NULL on Error/Empty. Please suggest approach to handle the nested_path exception during empty/error set.

Regards,

Kamal V.

[pfefferf]

Maybe you want to invest some more time in your question and add your example data, the statement and the expected result.