Illustration strms046.htm shows the following process for row migration during dequeue by a messaging client:

1. A user or application enqueues a row LCR that updates the hr.employees table into a queue 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.
2. A messaging client dequeues the LCR and transforms the UPDATE into a DELETE because the change satisfies a subset rule.