"itcollege" - 1 õppematerjal

14_yl

eesnimi||' '||y.perenimi); dbms_output.put_line('--puudub kodutoo ainetes--'); for aine in esitamata (y.id) loop dbms_output.put_line(aine.nimetus); end loop; end loop; end; / lesanne 13------------------------------------------------------------------------------ -- CREATE TABLE defektiga ( eesnimi varchar2(20), perenimi varchar2(20), email varchar2(50)); INSERT INTO defektiga values ('Vaino', 'Erilaid', 'vaino@itcollege.ee'); INSERT INTO defektiga values ('Kristo', 'Harakas', '[email protected]'); INSERT INTO defektiga values ('Priit', 'Jrisoo', '[email protected]'); INSERT INTO defektiga values ('Indrek', 'Karolin', '[email protected]'); INSERT INTO defektiga values ('Kristi',  'Karu', '[email protected]'); INSERT INTO defektiga values ('Kristjan', 'Krgesaar', '[email protected]'); INSERT INTO defektiga values ('Tnis',