Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Regular Expressions Functions

 

Regexp_Substr

REGEXP_SUBSTR returns part of a string. The complete syntax of REGEXP_SUBSTR is: REGEXP_SUBSTR(String to search, Pattern, [Position, [Occurrence, [Return-option, [Parameters]]]]) SQL> SQL> SELECT REGEXP_SUBSTR('Yababa dababa do','a.a') FROM dual; REG --- aba SQL>