1. Cache Guide
  2. Compatibility Between TimesTen and Oracle Databases
  3. SQL Compatibility
  4. SELECT Statements

SELECT Statements

TimesTen supports a subset of clauses of a SELECT statement that are supported by the Oracle Database:

  • FOR UPDATE

  • ORDER BY, including NULLS FIRST and NULLS LAST

  • GROUP BY, including ROLLUP, 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.

TimesTen does not support the CONNECT BY clause.