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!

false-positive syntax highlighting for MERGE

Mike KutzMar 14 2024
  • DB: 23.3 Free (VirtualBox)
  • VS Code: 23.4.1
  • SQL Developer: 23.1.0

I'm not sure if this has been registered. (I feel like that it has been)

But, the values keyword is flagged as Invalid when used in the using clause of a merge statement

sample code

merge into dual a
  using (values ('Y') ) b(dummy)
on (a.dummy = b.dummy)
when not matched then insert (dummy) values (b.dummy);

VS Code:

SQL Developer:

This post has been answered by thatJeffSmith-Oracle on Mar 14 2024
Jump to Answer
Comments
Post Details
Added on Mar 14 2024
3 comments
115 views