Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- CURSOR CStudent IS SELECT ID_Student, Nazwisko, Imie FROM Studenci;
- FUNCTION PDodStudent (pId VARCHAR2) RETURN NUMBER IS
- x NUMBER;
- BEGIN
- SELECT SUM(Punkty) INTO x FROM Egzaminy WHERE ID_Student = pId;
- IF x IS NULL THEN RETURN -1;
- ELSE
- RETURN x;
- END IF;
- END PDodStudent;
- BEGIN
- FOR vC IN CStudent LOOP
- DBMS_OUTPUT.put_line(PDodStudent(vc.Id_Student)) ;
- END LOOP;
- END ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement