Skip to Main Content

SQL Developer for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Bug: Syntax Error When Using JSON_TRANSFORM With INTERSECT Operation

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:

This post has been answered by Philipp Salvisberg on Apr 15 2025
Jump to Answer
Comments
Post Details
Added on Dec 15 2024
1 comment
112 views