The concatenation operator (
||) concatenates character strings. For example,
SELECT last_name || ', ' || first_name AS full_name FROM employee
If one of the operand is null, the result is null. In the example above, if in one of the rows “last_name” or “first_name” is null, the value of “full_name” is null.