DECLARE 
CURSOR rf_cr IS SELECT countryid FROM mine_country;
TYPE rf IS REF CURSOR; 
rc rf;
id NUMBER;
BEGIN
FOR a IN rf_cr LOOP
EXECUTE IMMEDIATE 'select count(cityid) from mine_city where countryid=:a' INTO id USING a.countryid; 
END LOOP;
END;