translate vs replace : REPLACE « Char Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Char Functions
  3. REPLACE

translate vs replace

 
SQL>
SQL> select translate('beer bucket','beer','milk') as translate
  2  ,      replace  ('beer bucket','beer','milk') as replace_1
  3  ,      replace  ('beer bucket','beer')        as replace_2
  4  from   dual;

TRANSLATE   REPLACE_1   REPLACE
----------- ----------- -------
miik muckit milk bucket  bucket

SQL>








Related examples in the same category

1.Replace: returns a string in which every occurrence of the pattern_to_find has been replaced with pattern_to_replace_by
2.REPLACE() replaces every occurrence of the string specified as the search_string with the replacement_string.
3.Syntax: REPLACE (, [,])
4.Remove a letter from string with replace function
5.REPLACE('This is a test','t','XYZ')
6.REPLACE: Replace with string every time it occurs
7.If not found, then the replacing does not occur
8.select replace( 'Oracle is great!', 'great', 'awesome' )
9.REPLACE('OPS$SPORANO', 'OPS$')