Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- wyjatek EXCEPTION;
- CURSOR przedmioty IS SELECT id_egzaminator AS ide, COUNT(*) AS COUNT, data_egz, id_student FROM egzaminy GROUP BY id_egzaminator, data_egz, id_student;
- egzaminator egzaminatorzy%ROWTYPE;
- BEGIN
- FOR przedmiot IN przedmioty LOOP
- BEGIN
- IF przedmiot.COUNT >= 5 THEN
- RAISE wyjatek ;
- END IF;
- EXCEPTION
- WHEN wyjatek THEN
- SELECT * INTO egzaminator FROM EGZAMINATORZY WHERE ID_EGZAMINATOR=przedmiot.ide;
- DBMS_OUTPUT.put_line(egzaminator.nazwisko || ' ' || egzaminator.imie);
- END;
- END LOOP;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement