--moredroplist condition多选设计
if (p_droplist is null or upper(p_droplist) = 'ALL') then
v_condition := v_condition;
else
--droplistID: "droplist1,droplist2,droplist3"
v_droplist := replace(p_droplistid,',',''',''');
v_condition :=v_condition || ' and a.droplist in ( ''' || v_droplist||''') ';
end if;
if (p_droplist is null or upper(p_droplist) = 'ALL') then
v_condition := v_condition;
else
--droplistID: "droplist1,droplist2,droplist3"
v_droplist := replace(p_droplistid,',',''',''');
v_condition :=v_condition || ' and a.droplist in ( ''' || v_droplist||''') ';
end if;