DECLARE
    CURSOR CURSE IS
    SELECT  ET.NUM_ET,
            ET.NOM_ET,
            ET.PRENOM_ET,
            M.CODE,
            ((NVL(MOY_CC,0)*COEFF_CC)+(NVL(MOY_TEST,0)*COEFF_TEST)) / (COEFF_CC + COEFF_TEST) NOTE_GLOB
    FROM    ETUDIANT ET
    JOIN    NOTATION N ON ET.NUM_ET = N.NUM_ET
    JOIN    MODULE M ON N.CODE = M.CODE
    WHERE   ET.ANNEE = 2;
BEGIN
    FOR E IN CURSE
    LOOP
        INSERT INTO RESULTAT VALUES (E.NUM_ET, E.NOM_ET, E.PRENOM_ET, E.CODE, E.NOTE_GLOB);
    END LOOP;

    COMMIT;
END;