REGEXP_LIKE_UDF (STRING, STRING)
Definition
This user-defined function (UDF) is used to support the Oracle REGEXP_LIKE functionality.
REGEXP_LIKE_UDF(COL STRING, PATTERN STRING) Parameters
COL STRING
The string to be evaluated with the pattern.
PATTERN STRING
The pattern to be checked.
Returns
Returns a boolean expression. True if the pattern matches the string; otherwise, false.
Usage example
Input:
SELECT REGEXP_LIKE_UDF('San Francisco', 'San* [fF].*');Output:
TRUELast updated