tech on the net
Home About Us Feedback Site Map


Access Excel Word


SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker


C Language


ASCII Table Linux UNIX Java Clipart Joke of the Moment

Other Sites

CheckYourMath BigActivities DigMinecraft
Share this page:

Oracle/PLSQL: || Operator

Learn how to use the Oracle/PLSQL || concatenate operator with syntax and examples.


The Oracle/PLSQL || operator allows you to concatenate 2 or more strings together.


The syntax for the Oracle/PLSQL || operator is:

string1 || string2 || string_n

Parameters or Arguments

string1 is the first string to concatenate.

string2 is the second string to concatenate.

string_n is the nth string to concatenate.

Applies To

The || operator can be used in the following versions of Oracle/PLSQL:

  • Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i


Let's look at some Oracle || operator examples and explore how to use the || operator in Oracle/PLSQL.

For example:

'Tech on' || ' the Net' would return 'Tech on the Net'
'a' || 'b' || 'c' || 'd' would return 'abcd'