Alternative Quote (q) Operator

•Specify your own quotation mark delimiter
•When we want to use ' in the table

Select department_name ||q'(, it's assigned Manager Id: )'|| manager_id "Department and Manager"
from departments;