triggers

[pyromiyuve]

Hola trata esto:

create or replace trigger "EMPLEADOS_T1"
BEFORE
insert or update or delete on "EMPLEADOS"
DECLARE
sumasalario NUMBER(4,0);
sumacomision NUMBER(4,0);
BEGIN
select sum(salario) into sumasalario from empleados;
select sum(comision) into sumacomision from empleados;
UPDATE total
set saldo_total = sumasalario + sumacomision,
where (Aqui va con que identificas a "total" Ej: new.Id o old.Id = Id);
end;
​/
(el / en oracle da la instruccion de compilar y ejecutar)

Saludos