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