SQL Operators
TimesTen supports a subset of operators and predicates that are supported by the Oracle Database:
- unary
-
+, -, *, /
-
=, <, >, <=, >=, <>, !=
||
IS NULL
,IS NOT NULL
LIKE
(Oracle DatabaseLIKE
operator ignores trailing spaces, but TimesTen does not)BETWEEN
IN
NOT IN
(list)AND
OR
+
(outer join)ANY
,SOME
ALL
(list)EXISTS
UNION
MINUS
INTERSECT
- To run a bitwise
AND
operation of two bit vector expressions, TimesTen uses the ampersand character (&
) between the expressions while Oracle Database uses theBITAND
function with the expressions as arguments.