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

SQL Subqueries

TimesTen supports a subset of subqueries that are supported by the Oracle Database.

  • IN (subquery)
  • >,<,= ANY (subquery)
  • >,=,< SOME (subquery)
  • EXISTS (subquery)
  • >,=,< (scalar subquery)
  • Subqueries in WHERE clause of DELETE/UPDATE
  • Subqueries in FROM clause
  • Subquery factoring clause (WITH constructor)

Note:

A nonverifiable scalar subquery is a scalar subquery whose 'single-row-result-set' property cannot be determined until runtime. TimesTen allows at most one nonverifiable scalar subquery in the entire query and the subquery cannot be specified in an OR expression.