3 Replies Latest reply on Jan 16, 2018 10:30 PM by Vadim Tropashko-Oracle

    False positive parser error in SQL Developer when using MERGE INTO view

    Danilo Piazzalunga

      Using SQL Developer 17.4.0.355.2349, I'm getting a parser error when using a MERGE statement on an inline view. For example:

       

      merge into (select * from employees) d

      using (select * from employees) s

      on (d.employee_id = s.employee_id)

      when not matched then insert (employee_id) values (9999);

       

      The error can be seen in the attached screenshot:

       

      Schermata del 2018-01-14 16-20-33.png

       

      The MERGE statement runs correctly.

       

      Regards,

      Danilo