Concatenation Operator

• You can link the the columns to other columns by using concatenation operator(||).
• Creates a resultant column that is a character expression.

Example :

SELECT name || job AS "Employees" FROM dept;