REPLACE: Replace with string every time it occurs : REPLACE « Char Functions « Oracle PL / SQL






REPLACE: Replace with string every time it occurs

 


SQL>
SQL> -- Replace with string every time it occurs.
SQL>
SQL> SELECT REPLACE ('This is a test',' is ',' may be ') FROM dual;

REPLACE('THISISATE
------------------
This may be a test

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.If not found, then the replacing does not occur
7.select replace( 'Oracle is great!', 'great', 'awesome' )
8.REPLACE('OPS$SPORANO', 'OPS$')
9.translate vs replace