Regular Expression

- Regular expressions offer a great deal of power for searching and manipulating text by enabling the pattern to search - to extract text matching a pattern – transform one pattern into another
- Don’t be intimidated by its seemingly arcane syntax. Patterns are fuzzy.

*  REGEXP_COUNT
*  REGEXP_LIKE
*  REGEXP_REPLACE
*  REGEXP_INSTR
*  REGEXP_SUBSTR

- REGEXP_COUNT is working with Oracle 11g databases and the rest of the above commands are working with Oracle 10g.
- It is designed primarily for use in the WHERE clause of a SELECT statement.