"kristoh" - 1 õppematerjal

14_yl

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', '[email protected]'); INSERT INTO defektiga values ('Kristo', 'Harakas', 'kristoh@tele2.ee'); 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', 'Lanno', '[email protected]'); INSERT INTO defektiga values ('Siiri',