Advertisement
Guest User

Untitled

a guest
Mar 19th, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.43 KB | None | 0 0
  1. DECLARE
  2.   cnt NUMBER(20);
  3.   CURSOR c1 IS SELECT ID_EGZAMINATOR, IMIE FROM EGZAMINATORZY;
  4.   exc EXCEPTION;
  5. BEGIN
  6.   FOR vCur IN c1 LOOP
  7.     BEGIN
  8.         SELECT COUNT(ID_EGZAMINATOR) INTO cnt FROM egzaminy WHERE ID_EGZAMINATOR = vCur.ID_EGZAMINATOR;
  9.         IF cnt=5 THEN RAISE exc; END IF;
  10.       EXCEPTION
  11.         WHEN exc THEN
  12.         DBMS_OUTPUT.Put_line(vCur.ID_EGZAMINATOR || ' ' ||vCur.IMIE) ;
  13.     END ;
  14.   END LOOP ;
  15. END ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement