This is a description of writequicks7.gif. Using the SQL statements in the figure, the image shows the following row 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.

After the INSERT, DELETE and 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.