動的に複数の曖昧条件でSELECTを行う

サンプルSQL

with dynamicLikeCondition AS (
	select 'A%' AS VALUE from dual
	union all
	select '%B1' AS VALUE from dual
	union all
	select '%C%' AS VALUE from dual
)
SELECT
	M.*
FROM MyTable M
WHERE EXISTS(SELECT * FROM dynamicLikeCondition COND WHERE M.KEY like COND.VALUE)