whenMatchedUpdate

fun whenMatchedUpdate(and: Op<Boolean>? = null, deleteWhere: Op<Boolean>? = null, body: (UpdateStatement) -> Unit)

Defines an update operation to be executed when a matching record is found in the destination table.

Parameters

and

An additional optional condition Op to specify when the update should occur.

deleteWhere

Applicable only to Oracle SQL. A condition Op used to indicate condition of row deletion. Oracle SQL does not support separate "delete" clause.

body

A lambda to define the UpdateStatement which sets the values of columns in the matching records.