Translate replaces a string character by character : TRANSLATE « Conversion Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Conversion Functions
  3. TRANSLATE

The general format for this function is:

TRANSLATE(string, characters_to_find, characters_to_replace_by)

SQL>
SQL>
SQL> SELECT TRANSLATE('Mississippi', 's','S') FROM dual;

TRANSLATE('
-----------
MiSSiSSippi

SQL>








15.9.TRANSLATE
15.9.1.Translate replaces a string character by character
15.9.2.Using the TRANSLATE() Function
15.9.3.Pass column values to TRANSLATE()
15.9.4.Use TRANSLATE() to convert numbers
15.9.5.Use TRANSLATE() with column
15.9.6.select translate('beer bucket','beer','milk') as translate