Как переделать запрос DELETE на MERGE?
Как переделать такой запрос DELETE, на запрос с MERGE?
DELETE FROM BpmsExecutionEntityImpl E where exists (select HPI.* from
BpmsHistoricProcessInstanceEntityImpl HPI where HPI.id = E.processInstanceId)
and rowid in (SELECT ri FROM (select rowid ri, rownum rn from BpmsExecutionEntityImpl E where
rownum < ${rnMax} ORDER BY E.id) WHERE rn > ${rnMin})
Использую СУБД Oracle 12C.