In Oracle/PLSQL, the || operator allows you to concatenate 2 or more strings together.
Syntax
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 11g, Oracle 10g, Oracle 9i, Oracle 8i
For Example
| 'Tech on' || ' the Net' | would return 'Tech on the Net' |
| 'a' || 'b' || 'c' || 'd' | would return 'abcd' |
