Java调用Oracle存储过程时，给in语句传入参数的方式

select * from mz.tManage  where foperator in(

select regexp_substr('ww0,909','[^,]+',1,rownum)net_code from dual connect by rownum <= (length('ww0,909') -

length(REGEXP_REPLACE('ww0,909', ',','')) + 1))

更多方法请参考:

http://blog.youkuaiyun.com/u010590016/article/details/40435327