1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| DECLARE
semaine_en_cours VARCHAR2(2);
BEGIN
SELECT TO_CHAR(SYSDATE, 'IW') INTO semaine_en_cours FROM DUAL;
SELECT COUNT(nu_int),
TO_CHAR(TO_DATE(da_ap, 'YYYY-MM-DD'), 'IW') AS Semaine,
TO_CHAR(TO_DATE(da_ap, 'YYYY-MM-DD'), 'YYYY') AS Annee
FROM EN_COURS
WHERE v_fonc = 'TX'
AND TO_CHAR(TO_DATE(da_ap, 'YYYY-MM-DD'), 'YYYY') = '2023'
AND TO_CHAR(TO_DATE(da_ap, 'YYYY-MM-DD'), 'IW') = semaine_en_cours
GROUP BY TO_CHAR(TO_DATE(da_ap, 'YYYY-MM-DD'), 'IW'), TO_CHAR(TO_DATE(da_ap, 'YYYY-MM-DD'), 'YYYY');
END;
/ |
Partager