The concatenation operator manipulates character strings. The following table describes the supported operators.
Table 6: 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.
