REPLACE()

Syntax: REPLACE(stringold_stringnew_string)

 

Description of replace.eps follows

Replace(): Allows us to replace one word or character with another.

 

— The REPLACE() REPLACES one string with another
SELECT REPLACE(‘Floyd’, ‘F’, ‘L’) AS REPLACED
FROM DUAL;

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top