Replace function Oracle

Replace function Oracle
Posted on September 24, 2012 by sqlandplsql
Replace function replaces the string with another string if it matches. It is a character function in Oracle. Replace function is case-sensitive.


Syntax:-


REPLACE(‘input string’,’find_string’,’replace_string’);


Example:-


1. Below query replaced ‘sql’ with ‘sequel’


SQL> select replace(‘sqlandplsql’,’sql’,’sequel’) as replace_string from dual;


REPLACE_STRING
—————–
sequelandplsequel