A literal is a character,date,number included within the select list.Date and character literals are enclosed with single quotes.
SELECT lastname || 'is a' jobocode as "EmpDetails" FROM Employee;
The result would be
xyz is a VP
abc is a PRES
pqr is a VP