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 ofDELETE
/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.