REGEXP_SUBSTR('Mississippi', 'si', 1, 2, 'i') : REGEXP_SUBSTR « Regular Expressions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Regular Expressions
  3. REGEXP_SUBSTR

REGEXP_SUBSTR('Mississippi', 'si', 1, 2, 'i')

SQL> SELECT REGEXP_SUBSTR('Mississippi', 'si', 1, 2, 'i') FROM dual;

RE
--
si

SQL>








Related examples in the same category

1.REGEXP_SUBSTR(description,'ird|irs'): Treat a pattern as a group
2.REGEXP_SUBSTR('Yababa dababa do','(ab)\1')