SQL basics - ( SELECT ) - (For absolute beginners) - Tutorial 2

Concatenation 

SELECT first_name||' '||PHONE_NUMBER FROM employees;

SELECT 'The phone no of of Mr.'
  ||first_name
  ||' '
  ||last_name
  ||' is '
  ||PHONE_NUMBER AS "Employee Details"
FROM EMPLOYEES;

2