The following statement works in Oracle Database 23ai but produces a syntax error in the VS Code extension 24.3.1.
select json_transform(
'{"a":{"a1":1, "a2":2}, "b":{"b1":3, "b2":4}}',
merge '$.a' = path '$.b' format json
null on missing
ignore on mismatch
ignore on null
ignore on empty
);
Here's the screenshot showing the complete error message:
