Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE
- FUNCTION AANTAL_PERSONEN ( p_rolnr opnamepersoon.rolnr%TYPE
- , p_negnr opnamepersoon.negnr%TYPE)
- RETURN NUMBER
- IS
- v_aantal_personen NUMBER;
- BEGIN
- SELECT COUNT(persoonid) INTO v_aantal_personen
- FROM opnamepersoon
- WHERE rolnr = p_rolnr
- AND negnr = p_negnr;
- RETURN v_aantal_personen;
- END AANTAL_PERSONEN;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement