This allows you to change the compliance behavior for the REGEXP_LIKE condition. One or more entries correspond to the previous template.Ĭorresponds to the previous zero or one entry pattern.Ĭorresponds to the previous template n times.Ĭorresponds to the previous template at least n times.Ĭorresponds to the previous template at least n times, but not more than m times.
It corresponds to the n-th subexpression located in ( ) before \n.Ĭorresponds to a single element mappings that can be more than one character.Ĭorresponds to the beginning of a line or corresponds to the end of a line before a new line character.Ĭorresponds to the previous pattern of zero or more occurrences. Matching at least m times, but not more than n times. Used for group expressions as subexpressions. It is used to specify a nonmatching list where you try to match any character except for those on the list. It is used to specify a list of matches where you try to match any of the characters in the list. Used as “OR” to specify more than one alternative. When using match_parameter with ‘m’, it corresponds to the end of the string anywhere within the expression.Ĭorresponds to any character except NULL. When using match_parameter with ‘m’, it corresponds to the beginning of the string anywhere within the expression.Ĭorresponds to the end of the line. It can be a combination of the following values: MeaningĬorresponds to the beginning of the line. These can be the following data types: VARCHAR2, CHAR, NVARCHAR2, NCHAR, CLOB or NCLOB. expression – a symbolic expression such as a column or field.
REGEXP_LIKE ( expression_id, pattern_id ) Parameters and function arguments