Oracle REPLACE Function Introduction

The Oracle Replace function replaces a value in a string with a different value.

For example, you can replace each occurrence of a letter with a matching number. The format of REPLACE is as follows:

REPLACE (char, search_string [, replace_string]) if the value of the replace_string variable is not specified, it is deleted when the value of the search_string variable is found. The input can be any character data type--char, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB.

Here is the SQL and execution result after using the Replace function:

Select Replace('0123456789','0','a') fromDual--a123456789Select Replace('0123456789','0',"') fromDual--123456789Select Replace('0123456789','0') fromDual--123456789