Table of Contents
- Title and Copyright Information
- Preface
- What's New
-
1
Data Types
- Type specifications
- ANSI SQL data types
- Types supported for backward compatibility
- Character data types
- Numeric data types
- BINARY and VARBINARY data types
- Numeric precedence
- LOB data types
- ROWID data type
- Datetime data types
- TimesTen intervals
- Storage requirements
- Data type comparison rules
- Data type conversion
- Null values
- INF and NAN
- Overflow and truncation
- Underflow
- 2 Names, Namespace and Parameters
- 3 Expressions
-
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
- 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
-
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
- 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
- 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
- TRUNCATE TABLE
- UNLOAD CACHE GROUP
- UPDATE
- 7 Privileges
- 8 Reserved Words
- Index