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":[1,2,3,4,5,6,6], "b":[4,1,3,5,7]}',
union '$.a' = path '$.b[0 to 4]' format json
ignore on missing
error on mismatch
ignore on null
);
Here's the screenshot showing the complete error message:
