select translate('beer bucket','beer','milk') as translate : TRANSLATE « Conversion Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Conversion Functions
  3. TRANSLATE
SQL>
SQL>
SQL> select translate('beer bucket','beer','milk') as translate
  2  from   dual;

TRANSLATE
-----------
miik muckit

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