Concatenation Operator

•Links columns or character strings to other columns
•Is represented by two vertical bars (||)

Select last_name||' is a '||job_id "Concatenation"
From employees;