trigger

CREATE OR REPLACE TRIGGER "calc_salariototal"
BEFORE
UPDATE OR INSERT ON "EMPLEADOS"
FOR EACH ROW
BEGIN
	IF :new.commission_pct is null THEN
		:new.total_salary:=:new.salary;
	ELSE
		:new.total_salary:=:new.salary+(:new.commission_pct*:new.salary);
	END IF;
END "calc_salariototal";
/