The replace functions allows you to replace all occurences of one string with another.
The syntax for the replace function is:
replace ( string , search_string, change_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