REGEXP_SUBSTR('www.java2s.com Oracle','l[[:alpha:]]{4}') : Alpha « Regular Expressions « Oracle PL / SQL






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

REGEXP_SUBSTR('www.java2s.com Oracle','l[[:alpha:]]{4}')



SQL>
SQL> -- Returns the substring
SQL>
SQL> SELECT REGEXP_SUBSTR('www.java2s.com Oracle','l[[:alpha:]]{4}') AS result FROM dual;

R
-


SQL>
SQL>








Related examples in the same category

1.[:alpha:] matches characters only
2.REGEXP_REPLACE('Oracle www.java2s.com', 'l[[:alpha:]]{4}', 'demo')