Oracle_Concatenation Operator

Concatenation Operator

admin Operators, Oracle

Hey geeks,
This is another chapter of Operators. Concatenation Operator helps to concatenate two or more strings or columns. The output of concatenating two character strings is always a character string.
In Oracle database, two solid vertical bars (“||”) are used as Concatenation Operator. It is very simple to use. Have a look at the examples below.

Below query shows how we can concatenate two columns.

Ellen Abel
Sundar Ande
Mozhe Atkinson
David Austin
Hermann Baer

We can also concatenate any string value with a column.

First Name is Ellen
First Name is Sundar
First Name is Mozhe
First Name is David
First Name is Hermann

We can use this operator to concatenate numbers as well. You should try yourself, GO AHEAD.


  • If two CHAR data type strings are concatenated then the result will be of CHAR data type and is limited to 2000 characters.
  • If either string is of data type VARCHAR2 then the result will be of VARCHAR2 data type and is limited to 4000 characters if the initialization parameter is set to MAX_STRING_SIZE = STANDARD. If the initialization parameter is set to MAX_STRING_SIZE = EXTENDED then the output limit is 32767 characters.
  • If both the strings are of data type NUMBER, the result will be of VARCHAR2 data type.

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 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. […]


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 *