Oracle – Replace Function

REPLACE

admin Oracle , , , ,

Hi Geeks,
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?

Syntax:

REPLACE(expr, search_string, replacement_string)

expr
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.

search_string
User provides an argument as a string which needs to be replaced.

replacement_string
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.

Example-1

When we run above SQL statement, Oracle will check if first argument contains ‘J’ and replace all the ‘J’ with ‘BL’.

NAME
BLACK and BLUE

Let’s take one more example.

Example-2

OLD_VAL NEW_VAL
SWITZERLAND ENGLAND

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.

If you like this blog, do share with your friends and colleagues on your social media.
For more updates join my facebook group and do like my facebook page.

Thank you,
Kapil Kumar

Sharing is caring!

You May Also Like..

merge

SQL – MERGE Statement

Hi Devs, As we have already learned INSERT INTO and UPDATE statement, our next very important statement is MERGE. Merge […]

update2

SQL – UPDATE Statement part-2

Hi Geeks, In previous blog on UPDATE statement, we learnt, how can we update a column value with a string […]

update

SQL – UPDATE Statement part-1

Hi Geeks, We already have a separate blog on INSERT INTO statement. So today, we will talk about UPDATE statement […]

Leave a Reply

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