Chapter 6 SQL Language Elements
231
operator:
{ + | - | * | / | || | %
}
Anywhere.
Must be connected to the database.
None.
"Constants in expressions" on page 231
"Special values" on page 247
"Column names in expressions" on page 231
"SQL Functions" on page 303
"Subqueries in expressions" on page 232
"Search conditions" on page 239
"SQL Data Types" on page 263
"SQL Functions" on page 303
"Variables" on page 250
Expressions are formed from several different kinds of elements, discussed
in the following sections.
$ For information on functions, see "SQL Functions" on page 303. For
information on variables, see "Variables" on page 250.
♦ The IF condition is not supported in Adaptive Server Enterprise.
♦ Java expressions are not currently supported in Adaptive Server
Enterprise.
♦ For other differences, see the separate descriptions of each class of
expression, in the following sections.
Constants in expressions
Constants are numbers or strings. String constants are enclosed in
apostrophes (’single quotes’). An apostrophe is represented inside the string
by two apostrophes in a row.
Column names in expressions
A column name is an identifier preceded by an optional correlation name. (A
correlation name is usually a table name. For more information on
correlation names, see "FROM clause" on page 532.) If a column name has
characters other than letters, digits and underscore, it must be surrounded by
quotation marks (""). For example, the following are valid column names:
employee.name
Usage
Authorization
Side effects
See also
Description
Compatibility
To Next Page
Loading...