REPLACE() replaces every occurrence of the string specified as the search_string with the replacement_string. : REPLACE « Char Functions « Oracle PL / SQL






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

REPLACE() replaces every occurrence of the string specified as the search_string with the replacement_string. 

  
SQL>
Syntax: REPLACE(<string_expression>, <search_string> [, <replacement_string>])
SQL>
SQL>
SQL> SELECT
  2     REPLACE ('ABCDA', 'A','*')  replace_A,
  3     REPLACE ('ABCDA', 'A')      remove_A,
  4     REPLACE ('ABCDA',NULL)      null_search
  5  FROM dual;

REPLA REM NULL_
----- --- -----
*BCD* BCD ABCDA

SQL>
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.Syntax: REPLACE (, [,])
3.Remove a letter from string with replace function
4.REPLACE('This is a test','t','XYZ')
5.REPLACE: Replace with string every time it occurs
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