Advertisement
Guest User

Untitled

a guest
Dec 15th, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.57 KB | None | 0 0
  1. DECLARE
  2.     FUNCTION f1 (vid studenci.id_student%TYPE) RETURN BOOLEAN IS
  3.         vx CHAR(1) ;
  4.         BEGIN
  5.             SELECT DISTINCT 'x' INTO vx FROM egzaminy e
  6.                 WHERE e.id_student = vid ;
  7.             RETURN TRUE ;
  8.         EXCEPTION
  9.             WHEN NO_DATA_FOUND THEN RETURN FALSE ;
  10.     END f1;
  11. BEGIN
  12.     FOR vc1 IN (SELECT id_student, nazwisko, imie
  13.                 FROM studenci
  14.                 ) LOOP
  15.         IF NOT f1(vc1.id_student) THEN
  16.                 DBMS_OUTPUT.put_line(vc1.id_student) ;        
  17.         END IF;
  18.     END LOOP ;
  19. END ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement