Go to main content
1/13
Contents
Title and Copyright Information
Preface
Audience
Related documents
Conventions
Documentation Accessibility
What's New
New features in Release 18.1.4.4.0
New features in Release 18.1.4.1.0
New features in Release 18.1.3.1.0
New features in Release 18.1.2.1.0
New features in Release 18.1.1.2.0
New features in Release 18.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 nonpadded 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
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
Index
Scripting on this page enhances content navigation, but does not change the content in any way.