Procedure GETSalesIsREJECT
(
v_Count IN OUT NUMBER(10),
v_PromotionIDs VARCHAR2(500)
)
select Count(reject) from
(Select reject From tsalespromotion where PKID in(v_PromotionIDs )) a
where a.reject='F'
end GETSalesIsREJECT;
v_Count 是我要返回数量;
v_PromotionIDs 是一段以逗号分割的id,id定长
如123,345,789,987
我如何把他们分割出来,并查询?
Procedure GETSalesIsREJECT
(
v_Count IN OUT NUMBER(10),
v_PromotionIDs VARCHAR2(500)
)
V_NUM NUMBER:=1;
BEGIN
FOR I IN 1..4 LOOP
select SUBSTR(v_PromotionIDs,V_NUM,3) INTO V_OUT
from dual;
DBMS_OUTPUT.PUT_LINE(V_OUT);
V_NUM:=V_NUM+4;
END LOOP;
END;