This illustration shows the following process for row migration during dequeue by a messaging client:
A user or application enqueues a row LCR that updates the hr.employees
table at an Oracle database. In the LCR, the old value for the department_id
column is 50
. The new value for this column is 90
.
A messaging client dequeues the LCR and transforms the UPDATE
into a DELETE
because the change satisfies a subset rule.