1/12

Contents

Title and Copyright Information

Preface

• Audience
• Related documents
• Conventions
• Documentation Accessibility
• Technical support

What's New

• New features in Release 11.2.1.8.0
• New features in Release 11.2.1.7.0
• New features in Release 11.2.1.6.0
• New features in Release 11.2.1.4.0
• New features in Release 11.2.1.1.0

1 Data Types

• Type specifications
• ANSI SQL data types
• Types supported for backward compatibility in Oracle type mode
• TimesTen type mapping
• Character data types
  • CHAR
  • NCHAR
  • VARCHAR2
  • NVARCHAR2
• Numeric data types
  • Exact and approximate numeric data types
    • NUMBER
    • TT_BIGINT
    • TT_INTEGER
    • TT_SMALLINT
    • TT_TINYINT
    • Floating-point numbers
• BINARY and VARBINARY data types
• Numeric precedence
• 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 timezone 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
• Replication limits
• TimesTen type mode (backward compatibility)
  • Data types supported in TimesTen type mode
  • Oracle data types supported in TimesTen type mode

2 Names, Namespace and Parameters

• Basic names
• Owner names
• Compound identifiers
• Namespace
• Dynamic parameters
• Duplicate parameter names
• Inferring data type from parameters

3 Expressions

• ROWID specification
• ROWNUM specification
• Expression specification
  • SQL syntax
  • Description
  • Examples
• Subqueries
• Aggregate functions
• Constants
• Format models
  • Number format models
    • Number format elements
  • Datetime format models
  • Datetime format elements
  • Format model for ROUND and TRUNC date functions
  • Format model for TO_CHAR of TimesTen datetime data types
• ABS
• ADD_MONTHS
• ASCIISTR
• CASE
• CAST
• CHR
• CEIL
• COALESCE
• CONCAT
• DECODE
• EXTRACT
• FLOOR
• GREATEST
• LEAST
• LOWER and UPPER
• LPAD
• LTRIM
• MOD
• NCHR
• NLSSORT
• NUMTODSINTERVAL
• NUMTOYMINTERVAL
• NVL
• POWER
• ROUND (date)
• ROUND (expression)
• RPAD
• RTRIM
• SIGN
• SQRT
• String functions
  • SUBSTR, SUBSTRB, SUBSTR4
  • INSTR, INSTRB, INSTR4
  • LENGTH, LENGTHB, LENGTH4
• SYS_CONTEXT
• SYSDATE and GETDATE
• TO_CHAR
• TO_DATE
• TO_NUMBER
• TRIM
• TRUNC (date)
• TRUNC (expression)
• TT_HASH
• UID
• UNISTR
• USER functions
  • CURRENT_USER
  • USER
  • SESSION_USER
  • SYSTEM_USER

4 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
  • NCHAR and NVARCHAR2

5 SQL Statements

• Comments within SQL statements
• ALTER ACTIVE STANDBY PAIR
• ALTER CACHE GROUP
• ALTER FUNCTION
• ALTER PACKAGE
• ALTER PROCEDURE
• ALTER REPLICATION
• ALTER SESSION
• ALTER TABLE
• ALTER USER
• CALL
• COMMIT
• CREATE ACTIVE STANDBY PAIR
• CREATE CACHE GROUP
• CREATE FUNCTION
• CREATE INDEX
• CREATE MATERIALIZED VIEW
• CREATE MATERIALIZED VIEW LOG
• CREATE PACKAGE
• CREATE PACKAGE BODY
• CREATE PROCEDURE
• CREATE REPLICATION
  • CHECK CONFLICTS
• CREATE SEQUENCE
• CREATE SYNONYM
• CREATE TABLE
  • Column Definition
• CREATE USER
• CREATE VIEW
• DELETE
• DROP ACTIVE STANDBY PAIR
• DROP CACHE GROUP
• DROP FUNCTION
• DROP INDEX
• DROP [MATERIALIZED] VIEW
• DROP MATERIALIZED VIEW LOG
• DROP PACKAGE [BODY]
• DROP PROCEDURE
• DROP REPLICATION
• DROP SEQUENCE
• DROP SYNONYM
• DROP TABLE
• DROP USER
• FLUSH CACHE GROUP
• GRANT
• INSERT
• INSERT...SELECT
• LOAD CACHE GROUP
• MERGE
• REFRESH CACHE GROUP
• REFRESH MATERIALIZED VIEW
• REVOKE
• ROLLBACK
• SELECT
  • SelectList
  • TableSpec
  • DerivedTable
  • JoinedTable
• TRUNCATE TABLE
• UNLOAD CACHE GROUP
• UPDATE
  • Join update

6 Privileges

• System privileges
• Object privileges
• Privilege hierarchy
• The PUBLIC role

7 Reserved Words

Index