Summary of SQL Statements Supported in TimesTen

Table 6-1 shows a summary of the SQL statements in TimesTen. The second column indicates if the statement is supported in TimesTen Scaleout. Every statement except ALTER SEQUENCE is supported in TimesTen Classic.

Table 6-1 SQL statements supported in TimesTen

SQL statement Supported in TimesTen Scaleout?

ALTER ACTIVE STANDBY PAIR

N

ALTER CACHE GROUP

Y

ALTER FUNCTION

N

ALTER PACKAGE

N

ALTER PROFILE

Y

ALTER PROCEDURE

N

ALTER REPLICATION

N

ALTER SEQUENCE

Y

Not supported in TimesTen Classic.

ALTER SESSION

Y

ALTER TABLE

Y

Unsupported clauses:

Aging and column-based compression

Unsupported data types:

LOB columns are not supported in tables. LOB variables are supported in PL/SQL programs.

ALTER USER

Y

CALL

Y

COMMIT

Y

CREATE ACTIVE STANDBY PAIR

N

CREATE CACHE GROUP

Y static read-only with incremental autorefresh

CREATE FUNCTION

Y

CREATE INDEX

Y

CREATE MATERIALIZED VIEW

Y with restrictions

CREATE PACKAGE

Y

CREATE PACKAGE BODY

Y

CREATE PROCEDURE

Y

CREATE PROFILE

Y

CREATE REPLICATION

N

CREATE SEQUENCE

Y with TimesTen Scaleout specific BATCH clause.

CREATE SYNONYM

Y

CREATE TABLE

Y including CREATE TABLE... AS SELECT

Unsupported clauses:

Aging and column-based compression

Unsupported data types:

LOBs and ROWID

Distribution clause is not supported for global temporary tables.

CREATE USER

Y

CREATE VIEW

Y

DELETE

Y

DROP ACTIVE STANDBY PAIR

N

DROP CACHE GROUP

Y static read-only cache groups with incremental autorefresh

DROP FUNCTION

Y

DROP INDEX

Y

DROP MATERIALIZED VIEW

Y

DROP PACKAGE [BODY]

Y

DROP PROCEDURE

Y

DROP PROFILE

Y

DROP REPLICATION

N

DROP SEQUENCE

Y

DROP SYNONYM

Y

DROP TABLE

Y

DROP USER

Y

DROP VIEW

Y

FLUSH CACHE GROUP

N

GRANT

Y

INSERT

Y

INSERT...SELECT

Y

LOAD CACHE GROUP

Y static read-only cache groups with incremental autorefresh

MERGE

N

REFRESH CACHE GROUP

Y static read-only cache groups with incremental autorefresh

REVOKE

Y

ROLLBACK

Y

SELECT

Y

TRUNCATE TABLE

Y, but TRUNCATE TABLE is similar to a DDL statement that invalidates all commands that depend on the table being truncated. It is preferable to use the DELETE statement rather than the TRUNCATE statement to delete all rows in a table.

UNLOAD CACHE GROUP

Y static read-only cache groups with incremental autorefresh

UPDATE

Y