Fonction_modele

    CREATE OR REPLACE FUNCTION GET_BULLSHIT

        RETURN SYS_REFCURSOR

        AS

        C1 SYS_REFCURSOR;

        BEGIN

        OPEN C1

        FOR SELECT Intervention.id_intervention, equipements.id_equipement, modele.id_modele
        FROM intervention
        JOIN equipements ON intervention.id_equipement=equipements.id_equipement
        JOIN modele ON modele.id_modele=equipements.id_modele
        WHERE modele.id_modele NOT LIKE 441
        ORDER BY intervention.id_intervention;

      RETURN C1;

      END;