Вывести имя города и страны при помощи обхода 2-ух курсоров:

locations

countries

declare

loc_cur sys_refcursor;

n_loc_id integer;

c_id countries.country_id%TYPE;

c_name countries.country_name%TYPE;

rec_loc locations%ROWTYPE;

cursor c_location is

select l.country_id

, l.city

from locations l;

cursor c_country(c_id countries.country_id%TYPE) is

select c.country_name

from countries c

where c.country_id = c_id;

begin

for rec in c_location loop

c_id := rec.country_id;

open c_country(c_id);

fetch c_country into c_name;

close c_country;

dbms_output.put_line(rec.city);

dbms_output.put_line(c_name);

dbms_output.put_line('------------');

end loop;

end;