LOG_SALARY_INCREASE

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   LOG_SALARY_INCREASE

Simple Trigger of AFTER "UPDATE ON EMPLOYEE"

CREATE OR REPLACE TRIGGER Log_salary_increase
AFTER UPDATE ON EMPLOYEE
FOR EACH ROW
WHEN (new.SALARY > 1000)
BEGIN
    AppLogPk.ChangedSalary(:new.EMP_ID, :new.SALARY);
END

Name	Types	Description
<DEFAULT SCHEMA>.APPLOGPK	Package	Package, Interface
<DEFAULT SCHEMA>.EMPLOYEE	Table	Table
<DEFAULT SCHEMA>.APPLOGPK.ChangedSalary	Procedure	Procedure interface ChangedSalary(employeeId NUMBER,newSalary NUMBER), Package APPLOGPK
<DEFAULT SCHEMA>.EMPLOYEE.SALARY	Column	Column
<DEFAULT SCHEMA>.EMPLOYEE.EMP_ID	Primary Key	Column

Name	Types	Description
<DEFAULT SCHEMA>.EMPLOYEES.UpdateEmployeeName.Update	Update Statement	UPDATE EMPLOYEE SET emp_fname=fname, emp_lname=lname WHERE emp_Id = employeeId