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

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 Database LIKE 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 the BITAND function with the expressions as arguments.