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