Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

TRANSLATE

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>