Replacing a string using oreplace in Teradata

In Teradata, you can replace a string in a column by using oreplace.

Syntax:
SELECT oreplace('actual_string','string_to_replace','new_string')


Example:
SELECT oreplace('Forgetcode','Forget','Nice');

Output:
Nicecode