Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- CURSOR kursor IS
- SELECT AVG(o.Ocena) AS ocenka, gr.Nazwa FROM OCENA o, ZAJECIA z, GRUPA gr WHERE
- o.ID_ZAJECIA = z.ID_ZAJECIA AND z.ID_GRUPA = gr.ID_GRUPA
- GROUP BY gr.NAZWA;
- BEGIN
- FOR i IN kursor LOOP
- DBMS_OUTPUT.PUT_LINE(i.Nazwa||' '||i.ocenka);
- END LOOP;
- EXCEPTION
- WHEN INVALID_CURSOR THEN
- DBMS_OUTPUT.PUT_LINE('Blad kursora');
- WHEN NO_DATA_FOUND THEN
- DBMS_OUTPUT.PUT_LINE('Nie ma zadnych grup');
- WHEN OTHERS THEN
- DBMS_OUTPUT.PUT_LINE('Blad');
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement