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
deleteWhere
Applicable only to Oracle SQL. A condition Op
body
A lambda to define the UpdateStatement which sets the values of columns in the matching records.