Literal Character

• It is a character, number or date included in the SELECT list.
• Date and character literal values should be with in single quotation marks.

Example :

SELECT name || ' is a '|| job AS "Employee Details" FROM dept;