The replace functions allows you to replace all occurences of one string with another.

The syntax for the replace function is:

replace ( string search_stringchange_to)

string is the source string.

search_string is the character or set of characters you are trying to change or find. 

change_to is the string you want to replace the search_string with.

For example:

replace (‘This is a test’, ‘is’, ‘was’)

would return ‘This was a test’

replace (‘This is a test’, ‘i’, ‘a’)

would replace all occurences of ‘i’ characters with ‘s’ characters

Replace – Oracle SQL Function
Tagged on: