The TRANSLATE functions transforms text by using the specified pattern:
v_tx:= translate(string, search, replacement);
The TRANSLATE function takes search and replacement strings and creates character-to-character maps
The third parameter can't be NULL or an empty string. Otherwise, the result is always NULL.
SQL> declare
2 v1_tx VARCHAR2(20):='To be or not to be';
3 v2_tx VARCHAR2(20);
4 begin
5 v2_tx:= translate (v1_tx,'bo ','BO');
6 DBMS_OUTPUT.put_line(v2_tx);
7 end;
8 /
TOBeOrnOttOBe
PL/SQL procedure successfully completed.
SQL>