[Oracle] 다중 LIKE(REGEXP_LIKE)
·
Database
EDIT EM_MMT_LOG_201806 WHERE TRAN_ETC2='MASS' AND REGEXP_LIKE(TRAN_ETC1, '2018060800001|2018061100001|2018061100002') --AND TRAN_ETC1 (LIKE '%2018060800001%' or LIKE '%2018061100001%' or LIKE '%2018061100002%')