Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
Functions, 76 of 121
REPLACE
returns char with every occurrence of search_string replaced with replacement_string. If replacement_string is omitted or null, all occurrences of search_string are removed. If search_string is null, char is returned. This function provides a superset of the functionality provided by the TRANSLATE
function. TRANSLATE
provides single-character, one-to-one substitution. REPLACE
lets you substitute one string for another as well as to remove character strings.
SELECT REPLACE('JACK and JUE','J','BL') "Changes" FROM DUAL; Changes -------------- BLACK and BLUE
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|