Saturday, November 7, 2015

Oracle SQL: SELECT (Literal Character Strings)

Literal Character Strings
>> A literal is a character, a number, or a date that is included in the SELECT statement.
>> Date and character literal values must be enclosed by single quotation marks.

>> Each character string is output once for each row returned.

Example:
SELECT customer_name||'is a'||cust_id AS "Customer Details" FROM   customer;


                  <<Back       Next>>

No comments:

Post a Comment