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.
SELECT replace('JACK and JUE','J','BL') as NAME FROM dual;
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.
SELECT 'SWITZERLAND' AS old_val, replace('SWITZERLAND','SWITZER','ENG') AS new_val FROM dual;
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.