The LIKE conditions specify a test involving pattern matching. Whereas the equality operator (=) exactly matches one character value to another, the LIKE conditions match a portion of one character value to another by searching the first value for the pattern specified by the second. LIKE calculates strings using characters as defined by the input character set…

select * from CR_CLIENT_INFO
where REGEXP_LIKE (CI_CLIENT_NAME,’KHAI’,'i’)

1.’i’ specifies case-insensitive matching.
2.’c’ specifies case-sensitive matching.
3.’n’ allows the period (.)