Hope you guys are doing well.
REPLACE is very good function which helps to substitute a string. This function is pretty much easy to use.
Have a look at the syntax, isn’t it?
It can be a column name from a table or a string. If it is a char string, it must be enclosed in single quoration marks.
User provides an argument as a string which needs to be replaced.
User provides an argument as a string which should replace search_string argument.
This function searches whole search_string in expr and replace with the replacement_string.
Let’s understand the concept with some examples.
When we run above SQL statement, Oracle will check if first argument contains ‘J’ and replace all the ‘J’ with ‘BL’.
|BLACK and BLUE|
Let’s take one more example.
You can see in the above results. Using REPLACE function, we replaced ‘SWITZERLAND’ with ‘ENG’ and new value is ‘ENGLAND’. How easy it is!
If you have any questions/suggestions, please comment below or write me an email.