001 report builder 参数多选 oracle数据库

 

 

 

 

where aaa.AType in (SELECT REGEXP_SUBSTR(?, '[^,]+', 1, LEVEL) FROM DUAL
CONNECT BY REGEXP_SUBSTR(?, '[^,]+', 1, LEVEL) IS NOT NULL)
order by aaa.Yea, aaa.Quo

posted @ 2020-05-08 10:17  shu'sblog  阅读(261)  评论(0编辑  收藏  举报