Oracle/PLSQL: || 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:

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