SELECT Statements
TimesTen supports a subset of clauses of a SELECT
statement that are
supported by the Oracle Database:
-
FOR UPDATE
-
ORDER BY
, includingNULLS FIRST
andNULLS LAST
-
GROUP BY
, includingROLLUP
,GROUPING_SETS
and grouping expression lists -
Table alias
-
Column alias
-
Subquery factoring clause with constructor
Oracle Database supports flashback queries, which are queries against a database that is in some previous state (for example, a query on a table as of yesterday). TimesTen does not support flashback queries.