HOWTO : Rewrite Some Oracle SQL Constructs Which Are Not Supported in TimesTen (Doc ID 1481568.1)

Last updated on SEPTEMBER 23, 2016

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.1 and later
Information in this document applies to any platform.
As of Version 11.2.2, TimesTen has not implemented the entirety of Oracle SQL and it is not known when or even if TimesTen will support all SQL syntaxes which are valid in Oracle SQL.
***Checked for relevance on 01-Jan-2014***

Goal

In this Support Note 3 examples of SQL statements are provided which are valid in Oracle 11g but which are not supported in TimesTen 11.2.2. Each example includes an equivalent SQL statement which is valid in TimesTen; all examples have been tested against identical tables with identical rows  in Oracle and TimesTen to make sure that they produce identical result sets in both databases.  Finally, some comments are offered on the general question of how unsupported SQL syntaxes can be rewritten to be valid in TimesTen.

It is hoped that this Note will be expanded as we identify additional Oracle SQL syntax which does not work in TimesTen.


The following SQL statements which are valid in Oracle return parsing errors when run against TimesTen:

(1)

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms