Concatenation Operator The concatenation operator manipulates character strings. The following table lists the only supported concatenation operator. Table 19. 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.