declare
cursor crs_org(p_hrc_code number) is (select * from TB_PUB_COUNTRY_NETCODE where countryname like p_hrc_code);
v_org_rec csr_org%rowtype;
begin
open crs_org('长沙%');
loop
fetch crs_org into v_org_rec;
exit when crs_org%notfound;
end loop;
close crs_org;
end;
cursor crs_org(p_hrc_code number) is (select * from TB_PUB_COUNTRY_NETCODE where countryname like p_hrc_code);
v_org_rec csr_org%rowtype;
begin
open crs_org('长沙%');
loop
fetch crs_org into v_org_rec;
exit when crs_org%notfound;
end loop;
close crs_org;
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货