REGEXP_SUBSTR extends the functionality of the SUBSTR function by letting you search a string for a regular expression pattern . It is also similar to REGEXP_INSTR , but instead of returning the position of the substring, it returns the substring itself.