SQL Tutorial Home

How to Replace Substrings

Oracle provides the following basic string replacement function:

select replace(fruit_name,'ap','AP') from fruits;