Trigger to Retrieve Last Record Inserted in PL-SQL Table

Question

I have a Rigger that after being inserted a new user in the table tFunctioning I must fill another table tPlanoSaude with the data of the employee.

employee table

table Health Plan

Code of the Trigges

 CREATE OR REPLACE TRIGGER INSERTFUNCIONARIO 
    BEFORE INSERT ON tfuncionario 
    BEGIN
      INSERT INTO tPlanoSaude VALUES(
          :old.TFUNCIONARIO.MATRICULA,
          :old.TFUNCIONARIO.NOME);
    END;

Error message:

Answer 1

The variable :NEW and :OLD is already the table itself with the inserted and Deleted data respectively, it is not neecssário to pass the table: :NEW.TABELA.CAMPO

Only :NEW.CAMPO, where :NEW already refers to your table.

Answer 2

I managed to run Rigger with this code snippet:

CREATE OR REPLACE TRIGGER INSERTFUNCIONARIO 
BEFORE INSERT ON tfuncionario 
FOR EACH ROW
BEGIN
  INSERT INTO tPlanoSaude VALUES(:new.matricula,:new.MATRICULA);
END;