Table 1. SQL and PL/SQL interfaces for Oracle Regular Expressions.
SQL function | Description |
---|---|
REGEXP_LIKE | Determine whether pattern matches |
REGEXP_SUBSTR | Determine what string matches the pattern |
REGEXP_INSTR | Determine where the match occurred in the string |
REGEXP_REPLACE | Search and replace a pattern |