LIKE 정규표현식

SELECT 1 --REGEXP_INSTR(PRDLSTNM,'Watch',3,4,1,'i') IDX
 FROM TB_PRDLST_MASTR
WHERE PRDLST_ID = B.ROOT_PRDLST_ID
 AND  REGEXP_LIKE (PRDLSTNM,'watch','i');