Concatenation operator ||

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

Syntax

|| operator::=

Concatenation Operator

The SQL literal NULL is handled as an empty string.

Example:
Copy 
SELECT 'abc' || 'DEF';