oracle replace

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