CREATE TABLE logSalario
(  cpf NUMBER(10),
   velho NUMBER(6,2),
   novo NUMBER(6,2),
   data TIMESTAMP
);

 

CREATE OR REPLACE TRIGGER logSalario AFTER UPDATE ON empregado

FOR EACH ROW
BEGIN
 INSERT INTO logSalario(cpf, velho, novo, data) VALUES (:OLD.cpf, :OLD.salario, :NEW.salario, SYSTIMESTAMP); 
END;
/