Advertisement
Guest User

Untitled

a guest
May 23rd, 2019
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.41 KB | None | 0 0
  1. DECLARE
  2.     cursor c1 IS SELECT nazwa_p, id_przedmiot
  3.     FROM przedmioty ORDER BY 1 ;
  4.     x CHAR(1) ;
  5. BEGIN
  6.     FOR vc1 IN c1 loop
  7.         BEGIN
  8.             SELECT DISTINCT 'x' INTO x FROM egzaminy
  9.                 WHERE id_przedmiot = vc1.id_przedmiot ;
  10.         exception
  11.             WHEN no_data_found THEN
  12.                 dbms_output.put_line(vc1.nazwa_p) ;
  13.         END ;
  14.     END loop ;
  15. END ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement