动态sql
--v_in包含类似于'aa','bb','cc'的字符串
vnum number;
vstr varchar2(500);
begin
vstr:='select count(*) from tbname where colname in('||v_in||')';
execute immediate vstr into vnum;
...
end;
--v_in包含类似于'aa','bb','cc'的字符串
vnum number;
vstr varchar2(500);
begin
vstr:='select count(*) from tbname where colname in('||v_in||')';
execute immediate vstr into vnum;
...
end;
format :idGroup to '[A1],[A2],[A3]'