DDL Source for TRIGGER a1.DMTEST.EMP_TRIG1

This page was created on: 28 March 2017, 11:53

[ DB a1 Home ] [ Schema DMTEST Home ] [ TRIGGERS Home ] [ DDL Wizard Home ]

CREATE 
 trigger EMP_trig1 
 after update on DM_EMPLOYEE for each row
 BEGIN
   insert into DM_EMP_AUDIT (person_id,assignment_id, emp_id,first_name,last_name,full_name) 
      values (:new.person_id,:new.assignment_id, :new.emp_id,:new.first_name,:new.last_name,:new.full_name);
 END IL_trig1;


[ DDL Wizard Home ]

This page was generated by the public version of the Net 2000 Ltd. DDLWizard software. Net 2000 Ltd. publishes other useful software for Oracle databases: Data Masker which replaces sensitive information in test and development databases with realistic looking anonymous data and DataBee the simplest and easiest way to create referentially correct subsets of large Oracle databases.