More than 1 year has passed since last update.

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

oracle

Posted at 2023-07-27

サンプル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)

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up