REGEXP_REPLACE('This is a test', 't.+t','XYZ') : REGEXP_REPLACE « Regular Expressions « Oracle PL / SQL






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

REGEXP_REPLACE('This is a test', 't.+t','XYZ')


SQL> -- REGEXP_INSTR(String to search, Pattern, [Position, [Occurrence, [Return-option, [Parameters]]]])
SQL>
SQL> SELECT REGEXP_REPLACE('This is a test', 't.+t','XYZ') FROM dual;

REGEXP_REPLAC
-------------
This is a XYZ

SQL>
SQL>








Related examples in the same category

1.REGEXP_REPLACE('H1234 H4321 H2345','(.*) (.*) (.*)','\3, \2 \1')
2.REGEXP_REPLACE('Mississippi', 'si', 'SI', 1, 0, 'i')