Oracle TimesTen In-Memory Database SQL Reference Guide

About this Guide

Oracle TimesTen In-Memory Database is a high-performance, in-memory data manager that supports the ODBC (Open DataBase Connectivity) and JDBC (Java DataBase Connectivity) interfaces.

This guide is for application developers who use and administer TimesTen. It provides a reference for TimesTen SQL statements, expressions, and functions, including TimesTen SQL extensions.

To work with this guide, you should understand how database systems work. You should also have knowledge of SQL (Structured Query Language). See “Background reading” on page 2 if you are not familiar with these interfaces.

Including this guide, the TimesTen documentation set consists of these documents:

• Oracle TimesTen In-Memory Database Installation Guide. Contains information needed to install and configure TimesTen on all supported platforms.
• Oracle TimesTen In-Memory Database Introduction. Describes all the available features in the Oracle TimesTen In-Memory Database.
• Oracle TimesTen In-Memory Database Operations Guide. Provides information on configuring TimesTen and using the ttIsql utility to manage a data store. This guide also provides a basic tutorial for TimesTen.
• Oracle TimesTen In-Memory Database C Developer’s and Reference Guide and the Oracle TimesTen In-Memory Database Java Developer’s and Reference Guide. Provide information on how to use the full set of available features in TimesTen to develop and implement applications that use TimesTen.
• Oracle TimesTen In-Memory Database API Reference Guide. Describes all TimesTen utilities, procedures, APIs and provides a reference to other features of TimesTen.
• Oracle TimesTen In-Memory Database SQL Reference Guide. Contains a complete reference to all TimesTen SQL statements, expressions and functions, including TimesTen SQL extensions.
• Oracle TimesTen In-Memory Database Error Messages and SNMP Traps. Contains a complete reference to the TimesTen error messages and information on using SNMP Traps with TimesTen.
• Oracle TimesTen In-Memory Database TTClasses Guide. Describes how to use the TTClasses C++ API to use the features available in TimesTen to develop and implement applications.
• TimesTen to TimesTen Replication Guide. Provides information to help you understand how TimesTen Replication works and step-by-step instructions and examples that show how to perform the most commonly needed tasks. This guide is for application developers who use and administer TimesTen and for system administrators who configure and manage TimesTen Replication.
• TimesTen Cache Connect to Oracle Guide. Describes how to use Cache Connect to cache Oracle data in TimesTen data stores. This guide is for developers who use and administer TimesTen for caching Oracle data.
• Oracle TimesTen In-Memory Database Troubleshooting Procedures Guide. Provides information and solutions for handling problems that may arise while developing applications that work with TimesTen, or while configuring or managing TimesTen.

Download Oracle TimesTen In-Memory Database SQL Reference Guide