The image shows the following SQL statements:
INSERT INTO oratt.writetab VALUES (102, 'Cache'); DELETE FROM oratt.writetab WHERE pk=101; UPDATE oratt.writetab SET attr='Oracle' WHERE pk=100;
The following row is inserted into the
oratt.writetab TimesTen cache table:
pk attr 102 Cache
The row where
pk=101 is deleted from the
oratt.writetab TimesTen cache table. The row where
pk=100 in the
oratt.writetab TimesTen cache table is updated such that the value in the attr column is changed to Oracle.
UPDATE statements have been committed on the cache table in the writecache AWT cache group within the TimesTen database, they are automatically propagated to the
oratt.writetab cached Oracle table. As a result, the TimesTen cache table and the cached Oracle table contain the following rows:
pk attr 100 Oracle 102 Cache
End of description.