This illustration 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 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.