Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- cursor c1 IS SELECT nazwa_p, id_przedmiot
- FROM przedmioty ORDER BY 1 ;
- x CHAR(1) ;
- BEGIN
- FOR vc1 IN c1 loop
- BEGIN
- SELECT DISTINCT 'x' INTO x FROM egzaminy
- WHERE id_przedmiot = vc1.id_przedmiot ;
- exception
- WHEN no_data_found THEN
- dbms_output.put_line(vc1.nazwa_p) ;
- END ;
- END loop ;
- END ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement