Replacing a string in a column using oreplace in Teradata

1. Forget Code
2. Teradata
3. Replacing a string in a column using oreplace

SELECT oreplace(column_name, 'string_to_replace','new_string');

SELECT oreplace(Role,'EX-','');