Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE
- PROCEDURE PERIODE_MEESTE_OPNAMES
- AS
- v_periode periode%ROWTYPE;
- BEGIN
- SELECT * INTO v_periode FROM periode
- WHERE
- (SELECT datum FROM
- (
- SELECT datum, COUNT(datum) FROM opname
- GROUP BY datum
- ORDER BY COUNT(datum) DESC
- )
- WHERE ROWNUM = 1
- )
- BETWEEN begindatum AND einddatum;
- DBMS_OUTPUT.PUT_LINE(v_periode.begindatum);
- DBMS_OUTPUT.PUT_LINE(v_periode.einddatum);
- DBMS_OUTPUT.PUT_LINE(v_periode.plaatsnaam);
- END PERIODE_MEESTE_OPNAMES;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement