Literal character strings in Oracle

Posted by Bubbly under Others category on | Views : 2688
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
xyz is a VP
abc is a PRES
pqr is a VP

Comments or Responses

Login to post response