1 Reply Latest reply on Apr 16, 2014 12:36 PM by Steven Hawkins

    Insert on duplicate key update not working

    teiiduser Newbie


      Does Teiid support for Oracle?


      INSERT INTO table (a,b,c) VALUES (1,2,3) ON DUPLICATE KEY UPDATE c=c+1; 


      Trying to use this in the update query in transformation editor.

      It doesnt seem to work.


      Thank you!