Returns the concatenation from string1 and string2. This concatenation operator is equivalent to the CONCAT function.
string1
string2
|| operator::=
The SQL literal NULL is handled as an empty string.
NULL
SELECT 'abc' || 'DEF';
