'm' treats the source string as multiple lines. If you omit this parameter, the period does not match the newline character. 'n' allows the period (.), which is the match-any-character wildcard character, to match the newline character. You can specify one or more of the following values for match_parameter: Match_parameter is a text literal that lets you change the default matching behavior of the function. For a listing of the operators you can specify in pattern, please refer to Appendix C, ' Oracle Regular Expression Support'. If the datatype of pattern is different from the datatype of source_string, Oracle converts pattern to the datatype of source_string. It is usually a text literal and can be of any of the datatypes CHAR, VARCHAR2, NCHAR, or NVARCHAR2. It is commonly a character column and can be of any of the datatypes CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. Source_string is a character expression that serves as the search value. For more information, please refer to Appendix C, ' Oracle Regular Expression Support'.ĭescription of the illustration regexp_like_condition.gif This condition complies with the POSIX regular expression standard and the Unicode Regular Expression Guidelines. This condition evaluates strings using characters as defined by the input character set. REGEXP_LIKE is similar to the LIKE condition, except REGEXP_LIKE performs regular expression matching instead of the simple pattern matching performed by LIKE.

Oracle regular expression not like