Tuesday, December 2, 2014

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

No comments:

Post a Comment