Illustration strms046.htm 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 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
A messaging client dequeues the LCR and transforms the
UPDATE into a
DELETE because the change satisfies a subset rule.