3 Expressions

Expressions are used for the following purposes:

• The select list of the INSERT...SELECT statement

• A condition of the WHERE clause and the HAVING clause

• The GROUP BY and ORDER BY clauses

• The VALUES clause of the INSERT and MERGE statements

• The SET clause of the UPDATE and MERGE statements

The following sections describe expressions in TimesTen:

• Expression Specification

• Subqueries

• Constants

• Format Models

• CASE Expressions

• ROWID Pseudocolumn

• ROWNUM Pseudocolumn

• Pseudocolumns in TimesTen Scaleout