Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- cnt NUMBER(20);
- CURSOR c1 IS SELECT ID_EGZAMINATOR, IMIE FROM EGZAMINATORZY;
- exc EXCEPTION;
- BEGIN
- FOR vCur IN c1 LOOP
- BEGIN
- SELECT COUNT(ID_EGZAMINATOR) INTO cnt FROM egzaminy WHERE ID_EGZAMINATOR = vCur.ID_EGZAMINATOR;
- IF cnt=5 THEN RAISE exc; END IF;
- EXCEPTION
- WHEN exc THEN
- DBMS_OUTPUT.Put_line(vCur.ID_EGZAMINATOR || ' ' ||vCur.IMIE) ;
- END ;
- END LOOP ;
- END ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement