Table of Contents

• Title and Copyright Information
• About This Content
• What's New
  • New features in Release 22.1.1.1.0
• 1 Data Types
  • Type Specifications
  • ANSI SQL Data Types
  • Types Supported for Backward Compatibility
  • Character Data Types
    • CHAR
    • NCHAR
    • VARCHAR2
    • NVARCHAR2
  • Numeric Data Types
    • NUMBER
    • TT_BIGINT
    • TT_INTEGER
    • TT_SMALLINT
    • TT_TINYINT
    • Floating-Point Numbers
      • BINARY_DOUBLE
      • BINARY_FLOAT
      • FLOAT and FLOAT(n)
  • BINARY and VARBINARY Data Types
  • Numeric Precedence
  • LOB Data Types
    • BLOB
    • CLOB
    • NCLOB
    • Difference Between NULL and Empty LOBs
    • Initializing LOBs
  • ROWID Data Type
  • Datetime Data Types
    • DATE
    • TIME
    • TIMESTAMP
    • TT_DATE
    • TT_TIMESTAMP
  • TimesTen Intervals
    • Using Interval Data Types
    • Using DATE and TIME Data Types
    • Handling Time Zone Conversions
    • Datetime and Interval Data Types in Arithmetic Operations
    • Restrictions on Datetime and Interval Arithmetic Operations
  • Storage Requirements
  • Data Type Comparison Rules
    • Numeric Values
    • Date Values
    • Character Values
    • Binary and Linguistic Sorting
    • Blank-padded and Non-Padded Comparison Semantics
  • Data Type Conversion
  • Implicit Data Type Conversion
  • Null Values
  • INF and NAN
    • Constant Values
    • Primary Key Values
    • Selecting Inf and NaN (Floating-Point Conditions)
    • Expressions Involving Inf and NaN
  • Overflow and Truncation
  • Underflow
• 2 Names, Namespace and Parameters
  • Basic Names
  • Owner Names
  • Compound Identifiers
  • Namespace
  • Dynamic Parameters
  • Duplicate Parameter Names
  • Inferring Data Type from Parameters
• 3 Expressions
  • Expression Specification
  • Subqueries
  • Constants
  • Format Models
  • Number Format Models
  • Datetime Format Models
  • Datetime Format Elements
  • Format Model for ROUND and TRUNC Date Functions
  • Format Model for TO_CHAR of TimesTen Datetime Data Types
  • CASE Expressions
  • ROWID Pseudocolumn
  • ROWNUM Pseudocolumn
  • Pseudocolumns in TimesTen Scaleout
    • Using Pseudocolumns to Locate Data
    • Working With Pseudocolumns and Duplicate Tables
    • Using Pseudocolumns to Locate a Local Element
    • Displaying the Element Id Associated With an Instance
• 4 Functions
  • Numeric Functions
  • Bitwise Functions
  • Character Functions Returning Character Values
  • Character Functions Returning Number Values
  • String Functions
  • LOB Functions
  • NLS Character Set Functions
  • General Comparison Functions
  • Null-Related Comparison Functions
  • Conversion Functions
  • Datetime Functions
  • Aggregate Functions
  • Analytic Functions
    • SQL Syntax
    • Parameters
  • Encoding and Decoding Functions
  • User and Session Functions
  • Function in TimesTen Scaleout
  • ABS
  • ACOS
  • ADD_MONTHS
  • ASCIISTR
  • ASIN
  • ATAN
  • ATAN2
  • AVG
  • BITAND
  • BITNOT
  • BITOR
  • BITXOR
  • CAST
  • CHR
  • CEIL
  • COALESCE
  • CONCAT
  • COS
  • COSH
  • COUNT
  • CURRENT_USER
  • DECODE
  • DENSE_RANK
  • ELEMENTIDCOMPUTE
  • EMPTY_BLOB
  • EMPTY_CLOB
  • EXP
  • EXTRACT
  • FIRST_VALUE
  • FLOOR
  • GREATEST
  • GROUP_ID
  • GROUPING
  • GROUPING_ID
  • INSTR, INSTRB, INSTR4
  • LAST_VALUE
  • LEAST
  • LENGTH, LENGTHB, LENGTH4
  • LN
  • LOG
  • LOWER and UPPER
  • LPAD
  • LTRIM
  • MAX
  • MIN
  • MOD
  • MONTHS_BETWEEN
  • NCHR
  • NLS_CHARSET_ID
  • NLS_CHARSET_NAME
  • NLSSORT
  • NULLIF
  • NUMTODSINTERVAL
  • NUMTOYMINTERVAL
  • NVL
  • POWER
  • RANK
  • REPLACE
  • ROUND (Date)
  • ROUND (Expression)
  • ROW_NUMBER
  • RPAD
  • RTRIM
  • SESSION_USER
  • SIGN
  • SIN
  • SINH
  • SOUNDEX
  • SQRT
  • SUBSTR, SUBSTRB, SUBSTR4
  • SUM
  • SYS_CONTEXT
  • SYSDATE and GETDATE
  • SYSTEM_USER
  • TAN
  • TANH
  • TIMESTAMPADD
  • TIMESTAMPDIFF
  • TO_BLOB
  • TO_CHAR
  • TO_CLOB
  • TO_DATE
  • TO_TIMESTAMP
  • TO_LOB
  • TO_NCLOB
  • TO_NUMBER
  • TRIM
  • TRUNC (Date)
  • TRUNC (Expression)
  • TT_HASH
  • UID
  • UNISTR
  • USER
  • VSIZE
• 5 Search Conditions
  • Search Condition General Syntax
  • ALL / NOT IN Predicate (Subquery)
  • ALL / NOT IN Predicate (Value List)
  • ANY / IN Predicate (Subquery)
  • ANY / IN Predicate (Value List)
  • BETWEEN Predicate
  • Comparison Predicate
  • EXISTS Predicate
  • IS INFINITE Predicate
  • IS NAN Predicate
  • IS NULL Predicate
  • LIKE Predicate
    • Pattern Matching for Strings of NCHAR, NVARCHAR2, and NCLOB Data Types
• 6 SQL Statements
  • Summary of SQL Statements Supported in TimesTen
  • Comments Within SQL Statements
  • Optimizer Hints
  • Statement Level Optimizer Hints
  • Optimizer Hints Supported in TimesTen Scaleout Only
    • TT_GridQueryExec Optimizer Hint
    • TT_PartialResult Optimizer Hint
    • TT_CommitDMLOnSuccess Optimizer Hint
  • ALTER ACTIVE STANDBY PAIR
  • ALTER CACHE GROUP
  • ALTER FUNCTION
  • ALTER PACKAGE
  • ALTER PROCEDURE
  • ALTER PROFILE
  • ALTER REPLICATION
  • ALTER SEQUENCE
  • ALTER SESSION
  • ALTER TABLE
  • ALTER USER
  • CALL
  • COMMIT
  • CREATE ACTIVE STANDBY PAIR
  • CREATE CACHE GROUP
  • CREATE FUNCTION
  • CREATE INDEX
  • CREATE MATERIALIZED VIEW
  • CREATE PACKAGE
  • CREATE PACKAGE BODY
  • CREATE PROCEDURE
  • CREATE PROFILE
  • CREATE REPLICATION
    • CHECK CONFLICTS
  • CREATE SEQUENCE
  • CREATE SYNONYM
  • CREATE TABLE
  • CREATE USER
  • CREATE VIEW
  • DELETE
  • DROP ACTIVE STANDBY PAIR
  • DROP CACHE GROUP
  • DROP FUNCTION
  • DROP INDEX
  • DROP MATERIALIZED VIEW
  • DROP PACKAGE [BODY]
  • DROP PROCEDURE
  • DROP PROFILE
  • DROP REPLICATION
  • DROP SEQUENCE
  • DROP SYNONYM
  • DROP TABLE
  • DROP USER
  • DROP VIEW
  • FLUSH CACHE GROUP
  • GRANT
  • INSERT
  • INSERT...SELECT
  • LOAD CACHE GROUP
  • MERGE
  • REFRESH CACHE GROUP
  • REVOKE
  • ROLLBACK
  • SELECT
    • WithClause
    • SelectList
    • TableSpec
    • JoinedTable
    • DerivedTable
    • GROUP BY Clause
      • SQL Syntax
      • Parameters
      • Examples
      • ROLLUP, CUBE and GROUPING SETS Clauses
  • TRUNCATE TABLE
  • UNLOAD CACHE GROUP
  • UPDATE
    • Join Update
• 7 Privileges
  • System Privileges
  • Object Privileges
  • Privilege Hierarchy
  • The PUBLIC Role
• 8 Reserved Words