Mega Code Archive
Categories
/
Oracle PLSQL
/
Regular Expressions
REGEXP_REPLACE(Mississippi, si, SI, 1, 0, i)
SQL> SELECT REGEXP_REPLACE('Mississippi', 'si', 'SI', 1, 0, 'i') FROM dual; REGEXP_REPL ----------- MisSIsSIppi SQL>