Oracle Interview Q&A, SQL in Oracle, REGEXP_SUBSTR

Oracle Real Time Scenario, SQL in Oracle, REGEXP_SUBSTR() #sql #oracle  #regexp


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. This function is useful if you need the contents of a match string but not its position in the source string. The function returns the string as VARCHAR2 or CLOB data in the same character set as source_char.