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

Parentheses

Parentheses in SQL

Hey time travellers, Though Parentheses are used pretty much everywhere in SQL but in this blog, we will talk about […]

Logical Conditions

Oracle – Logical Conditions

Hey time travellers, In this article, we will be discussing Logical Conditions. It is a very important aspect of SQL. […]

IN

Oracle – IN Condition

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

Leave a Reply

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