ALTER TABLE PATIENT ADD total_visite NUMBER NUMBER(10,0);

CREATE OR REPLACE TRIGGER total_visite_trg
AFTER INSERT ON VISITE
FOR EACH ROW
BEGIN
    update PATIENT set total_visite = total_visite + :new.PRIX where PATIENT.PATIENT_ID = :new.PATIENT
END;