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
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