Using Literal Character String
Example:
To print IS A as one string with column name employee
SELECT ENAME || ' IS A ' || JOB AS "EMPLOYEE" FROM EMP;