Concatenation operator
- Last Updated: May 12, 2026
- 1 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
The concatenation operator manipulates character strings. The following table describes the supported operators.
Concatenation operator
| Operator | Purpose | Example |
| || + | Concatenates character strings. | SELECT 'Name is ' || ename FROM emp; SELECT first_name + last_name FROM emp; |
The result of concatenating two character strings is another character string. If both character strings are of data type CHAR, the result is data type CHAR and is limited to 254 characters. If either string is of data type VARCHAR, the result is data type VARCHAR.
Note: The result of concatenating a null value to a non-null char column value with a concat operator (’+’ or ’ ||’) is non-null, unless both the column values are null. See Nullability for more information.