Alternative Quote (q) Operator

•      Specify your own quotation mark delimiter

•      Choose any delimiter

•      Increase readability and usability

SELECT department_name || q'[, it's assigned Manager Id:]'

|| manager_id  AS "Department and Manager"  FROM departments;

DEPARTMENT AND MANAGER

Internal Control, it’s assigned Manager ID: 200

Marketing, it’s assigned Manager ID: 201

…