This illustration 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 emp_dml_handler re-enqueues all events back into the streams_queue for processing by an application and applies DELETE row LCRs to a table named emp_del in the hr schema.