Concatenation Operator

Purpose: Combines two or more strings into one.Operator:

• || (double vertical bars)

Example:

SELECT first_name || ' ' || last_name AS full_name FROM employees;

Explanation: This creates a full name by concatenating first_name and last_name.