Illustration strms036.gif shows the following Streams configuration at the
One Streams queue named
streams_queue and owned by the user
One capture process named
capture_emp captures DML changes to the
hr.employees table and enqueues these changes into the
An apply process named
apply_emp that sends row LCRs involving the
hr.employees table to a DML handler, which is the
emp_dml_handler PL/SQL procedure. The apply process reenqueues all messages back into the
streams_queue for processing by an application.
DELETE operations on the
hr.employees table into
INSERT operations on the
hr.emp_del table and inserts these changes into the table.