TRANSLATE : CHAR VARCHAR2 Functions « PL SQL Data Types « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Data Types
3. CHAR VARCHAR2 Functions

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>
SQL>