Advertisement
Guest User

Untitled

a guest
Jul 20th, 2017
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.36 KB | None | 0 0
  1. CREATE OR REPLACE
  2. FUNCTION AANTAL_PERSONEN  ( p_rolnr opnamepersoon.rolnr%TYPE
  3.                           , p_negnr opnamepersoon.negnr%TYPE)
  4. RETURN NUMBER
  5. IS
  6.   v_aantal_personen NUMBER;
  7. BEGIN
  8.   SELECT COUNT(persoonid) INTO v_aantal_personen
  9.   FROM opnamepersoon
  10.   WHERE rolnr = p_rolnr
  11.   AND negnr = p_negnr;
  12.   RETURN v_aantal_personen;
  13. END AANTAL_PERSONEN;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement