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.