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, 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.