Literal character strings in Oracle

A literal is a character,date,number included within the select list.
Date and character literals are enclosed with single quotes.

For example,

SELECT lastname || 'is a' jobocode as "EmpDetails" FROM Employee;

The result would be

EmpDetails 
xyz is a VP
abc is a PRES
pqr is a VP