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 ...