Skip Headers
Oracle® TimesTen In-Memory Database SQL Reference
Release 11.2.1

Part Number E13070-09
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

What's New

This section lists new features for Release 11.2.1 that are documented in this reference and provides cross-references to additional information.

New features in Release 11.2.1.8.0

This section lists new features for Release 11.2.1.8.0 that are documented in this reference and provides cross-references to additional information.

You can create or drop a table, index or synonym in an active standby pair without stopping the replication agent. You can choose to have these statements replicated to the standby database. You can include a table in an active standby pair when the table is created. See the following statements for more details:

New features in Release 11.2.1.7.0

This section lists new features for Release 11.2.1.7.0 that are documented in this reference and provides cross-references to additional information:

New features in Release 11.2.1.6.0

This section lists new features for Release 11.2.1.6.0 that are documented in this reference and provides cross-references to additional information:

New features in Release 11.2.1.4.0

This section lists new features for Release 11.2.1.4.0 that are documented in this reference and provides cross-references to additional information:

New features in Release 11.2.1.1.0

This section lists new features for Release 11.2.1.1.0 that are documented in this reference and provides cross-references to additional information.

Access Control

PL/SQL support

The ALTER SESSION statement has been enhanced.

These statements are new:

These SQL functions are new:

Oracle In-Memory Database Cache (IMDB Cache)

These IMDB Cache features are new:

Asynchronous materialized views

Materialized views can be refreshed asynchronously. The CREATE MATERIALIZED VIEW statement has been enhanced. These statements are new:

RETURNING ... INTO clause

The DELETE, INSERT and UPDATE statements have been enhanced with the RETURNING...INTO clause.

ROWID data type

The ROWID data type has been implemented. See "ROWID data type".

Duplicate parameter names

TimesTen offers Oracle-style behavior for duplicated parameter names. See "Duplicate parameter names".

Bitmap indexes

You can create bitmap indexes. See "CREATE INDEX".

Set operators in subqueries

Set operators are allowed in subqueries. See "Subqueries".

Enhanced ":" parameter markers

":" parameter markers have been enhanced. See "Dynamic parameters".

Multiline C-style comments

You can use multiline C-style comments in SQL statements. See "Comments within SQL statements".

View and sequence names

A view and a sequence cannot have the same name. See "CREATE VIEW" and "CREATE SEQUENCE".