INSERT/DELETE/UPDATE/MERGE Statements

TimesTen supports certain DML statements that are also supported by the Oracle Database.

• INSERT INTO ... VALUES

• INSERT INTO ... SELECT

• UPDATE WHERE expression (expression may contain a subquery)

• DELETE WHERE expression (expression may contain a subquery)

TimesTen does not support updating of primary key values except when the new value is the same as the old value.