REGEXP_SUBSTR

will allow you to extract a substring from a string using regular expression pattern matching.

Syntax

REGEXP_SUBSTR( string, pattern [, start_position [, nth_appearance [, match_parameter [, sub_expression ] ] ] ] )