Advertisement
Guest User

Untitled

a guest
Dec 15th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.42 KB | None | 0 0
  1. SET serveroutput ON
  2. DECLARE
  3.     vx CHAR(1) ;
  4.     CURSOR c1 IS SELECT id_student, nazwisko, imie FROM studenci ;
  5. BEGIN
  6.     FOR vc1 IN c1 LOOP
  7.         BEGIN
  8.             SELECT DISTINCT 'x' INTO vx FROM egzaminy e
  9.                 WHERE e.id_student = vc1.id_student ;
  10.         EXCEPTION
  11.             WHEN NO_DATA_FOUND THEN
  12.                 DBMS_OUTPUT.put_line(vc1.id_student) ;        
  13.         END;
  14.     END LOOP ;
  15. END ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement