Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE
- PROCEDURE PERIODE_MINSTE_OPNAMES AS
- TYPE type_coll_periode
- IS TABLE OF periode%ROWTYPE
- INDEX BY PLS_INTEGER;
- t_per type_coll_periode;
- BEGIN
- SELECT p.begindatum, p.einddatum, p.plaatsnaam BULK COLLECT INTO t_per
- FROM periode p, opname o
- WHERE o.datum BETWEEN p.begindatum AND p.einddatum
- GROUP BY p.begindatum, p.einddatum, p.plaatsnaam
- HAVING COUNT(p.begindatum) = (SELECT MIN(COUNT(*))
- FROM periode p, opname o
- WHERE o.datum BETWEEN p.begindatum AND p.einddatum
- GROUP BY p.begindatum);
- FOR i IN 1..t_per.COUNT
- LOOP
- DBMS_OUTPUT.PUT(t_per(i).begindatum || ' ');
- DBMS_OUTPUT.PUT(t_per(i).einddatum || ' ');
- DBMS_OUTPUT.PUT_LINE(t_per(i).plaatsnaam);
- END LOOP;
- END PERIODE_MINSTE_OPNAMES;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement