## Database trigger used to "submit" a database "job" request.

Create or Replace Trigger EMP_Jobs 
After INSERT or UPDATE or DELETE on EMP
For each ROW
DECLARE
   id number;
   action varchar2(1) := ‘I’;
BEGIN
   if UPDATING then
      action := ‘U’;
   elsif
      DELETING then
      action := ‘D’;
   end if;
   dbms_job.submit (id, ‘Replicate_EMP(‘ ||
                        to_char(nvl(:NEW.emp_no,:OLD.emp_no)) ||
                        ‘,’’’ || action || ‘’’);’ );
END;