Oracle - PL/SQL - CONCATENATION Operator ||

In Oracle/PLSQL, the operator allows you to concatenate 2 or more strings together.

The syntax for the operator is:

string1 string2 string_n

string1 is the first string to concatenate.

string2 is the second string to concatenate.

string_n is the nth string to concatenate.

Applies To:

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

For example:

'24X7' 'Information For You'

would return '24X7 Information For You'.