1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
CREATE PROCEDURE Liste_Cages (proc_ID IN NUMBER)
IS
BEGIN
SELECT C.* FROM CAGE C, TYPE_ANIMAL TA, ANIMAL_EMPLOYE AE, SOIN S
WHERE S.DATESOINPREVU = CURRENT_DATE
AND S.IDCAGE = C.IDCAGE
AND C.IDTYPEANIMAL = TA.IDTYPEANIMAL
AND TA.IDTYPEANIMAL = AE.IDTYPEANIMAL
AND AE.IDEMPLOYE = proc_ID
UNION
SELECT C.* FROM CAGE C, ENTRETIEN E
WHERE C.IDCAGE = E.IDCAGE
AND ETATENTRETIEN = 0
AND E.IDCONCIERGE = proc_ID
UNION
SELECT C.* FROM CAGE C, ANIMAL A, DEMANDE_VETERINAIRE DV
WHERE C.IDCAGE = A.IDCAGE
AND A.IDANIMAL = DV.IDANIMAL
AND DV.ETATDEMANDE = 0
AND DV.IDVETERINAIRE = proc_ID
END; |
Partager