Concatenation Operator

A concatenation operator:

•      Links columns or character strings to other columns

•      Is represented by two vertical bars (||)

•      Creates a resultant column that is a character expression

SELECT   last_name||job_id AS "Employees"  FROM employees;

EMPLOYEES

John11111

Kery22222

…….