Module org.jooq
Package org.jooq

Interface MergeNotMatchedValuesStep12<R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12>


  • public interface MergeNotMatchedValuesStep12<R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12>
    This type is used for the Merge's DSL API.

    Example:

     DSLContext create = DSL.using(configuration);
    
     create.mergeInto(table)
           .using(select)
           .on(condition)
           .whenMatchedThenUpdate()
           .set(field1, value1)
           .set(field2, value2)
           .whenNotMatchedThenInsert(field1, field2)
           .values(value1, value2)
           .execute();
     
    Author:
    Lukas Eder