REGEXP_REPLACE('Mississippi', 'si', 'SI', 1, 0, 'i') : REGEXP_REPLACE « Regular Expressions « Oracle PL / SQL






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

REGEXP_REPLACE('Mississippi', 'si', 'SI', 1, 0, 'i')


SQL> SELECT REGEXP_REPLACE('Mississippi', 'si', 'SI', 1, 0, 'i') FROM dual;

REGEXP_REPL
-----------
MisSIsSIppi

SQL>








Related examples in the same category

1.REGEXP_REPLACE('This is a test', 't.+t','XYZ')
2.REGEXP_REPLACE('H1234 H4321 H2345','(.*) (.*) (.*)','\3, \2 \1')