Wednesday, August 17, 2016

regexp_like

SELECT :expr, 'narayan is my name raykar. ('
FROM   DUAL
WHERE regexp_like (:expr,'(^|\s)raykar($|\s|\W)','i' )

(^|\s) - starts with or has space
($|\s|\W) - ends with or has space or has a nonword character