Use the concatenation operator (||) to join two text strings together.

The following example provides an example of a concatenation operator used in a query:

SELECT firstname  || ' ' || lastname  from Employee;