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;
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.