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":[7,8,9]}',
copy '$.c' = path '$.b'
create on missing
error on null
error on empty
);
Here's the screenshot showing the complete error message:
