Concatenation Operator (||)

Returns the concatenation from string1 and string2. This concatenation operator is equivalent to the CONCAT function.

Syntax

|| operator::=

Concatenation Operator

Example
SELECT 'abc' || 'DEF';