17,377
社区成员
发帖
与我相关
我的任务
分享
open c_n_f for select WF_COUNTRIES.COUNTRY_NAME, FLAG_LOB.COUNTRY_FLAG from WF_COUNTRIES, FLAG_LOB, WF_WORLD_REGIONS where WF_COUNTRIES.COUNTRY_ID = FLAG_LOB.COUNTRY_ID and WF_COUNTRIES.REGION_ID = WF_WORLD_REGIONS.REGION_ID and wf_world_regions.region_name=region_n;
--可以的,类似
CREATE OR REPLACE PROCEDURE p_getdata(region_n VARCHAR2,
c_n_f OUT SYS_REFCURSOR) IS
BEGIN
OPEN c_n_f FOR
SELECT WF_COUNTRIES.COUNTRY_NAME, FLAG_LOB.COUNTRY_FLAG
FROM WF_COUNTRIES, FLAG_LOB, WF_WORLD_REGIONS
WHERE WF_COUNTRIES.COUNTRY_ID = FLAG_LOB.COUNTRY_ID
AND WF_COUNTRIES.REGION_ID = WF_WORLD_REGIONS.REGION_ID
AND wf_world_regions.region_name = region_n;
END;
/