Specifying Explicit Values

The SQL Standard provides flexibility for enhancing the information returned from a SELECT statement by allowing use of constant values such as character strings, numbers, dates, times, or a suitable combination of these items, in any valid expression used within a SELECT statement. The SQL Standard categorizes these types of values as literal values and specifies the manner in which they are defined.

Character String Literals

A character string literal is a sequence of individual characters enclosed in single quotes. Yes, we know that you are probably used to using double quotes to enclose character strings, but we’re presenting these concepts as the SQL Standard defines them. Figure 5-2 shows the diagram for a character ...

Get SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.