Oracle – Replace Function

REPLACE

admin Functions, 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_VALNEW_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..

IN

Oracle – IN Condition

Hey people, In this Oracle tutorial, we will learn how to use IN condition in SQL. IN condition is used […]

NULLIF

Oracle SQL_Null Related functions-3_NULLIF

Hi Aliens, Today, we will talk about another Null Related Function, NULLIF. You can read my notes on NVL, NVL2 […]

WHERE

SQL – WHERE clause

Hi DBgeek Army, Welcome back to the world of Oracle! Where clause helps to select desired rows or helps to […]

Leave a Reply

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