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

SQL Expressions

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

  • Column Reference
  • Sequence
  • NULL
  • ()
  • Binding parameters
  • CASE expression
  • ROWID pseudocolumn
  • ROWNUM pseudocolumn

TimesTen and Oracle Database treat literals differently. See the description of HexadecimalLiteral in Constants in Oracle TimesTen In-Memory Database SQL Reference.