REPLACE

REPLACE searches a string for a regular pattern, replaces it with another string, and returns the modified string.

Return Value

VARCHAR2 | CLOB

Syntax

REPLACE(char, search_string [, replacement_string ])

Arguments

char is the text expression that will be searched.

search_string is the text expression to search for.

replacement_string is the text expression that will replace search_string in char.

Example

REPLACE('JACK and JUE','J','BL') returns the string BLACK and BLUE.

Copyright © 2003, 2007, Oracle. All rights reserved.