The concatenation operator manipulates character strings. The following table lists the only supported concatenation operator.

Table 1. Concatenation Operator
Operator Purpose Example
|| Concatenates character strings. SELECT 'Name is' || ename FROM emp

The result of concatenating two character strings is the data type VARCHAR.