REGEXP_REPLACE « Regular Expressions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Regular Expressions
  3. REGEXP_REPLACE
1.REGEXP_REPLACE('This is a test', 't.+t','XYZ')
2.REGEXP_REPLACE('H1234 H4321 H2345','(.*) (.*) (.*)','\3, \2 \1')
3.REGEXP_REPLACE('Mississippi', 'si', 'SI', 1, 0, 'i')