The image shows the following SQL statements:

INSERT INTO customers VALUES (342, "West", "Jane Stone");
DELETE FROM customers WHERE cust_num=122;
UPDATE customers SET region="East" WHERE cust_num=663;

The following row is inserted into the sales.customers cached Oracle table:

342 West  Jane Stone

The row where cust_num=122 is deleted from the sales.customers cached Oracle table. The row where cust_num=663 in the sales.customers cached Oracle table is updated such that the value in the region column is changed to East. After the INSERT, DELETE and UPDATE statements have been committed on the cached Oracle table, they are automatically refreshed into the sales.customers cache table in the customer_orders read-only cache group within the TimesTen database. As a result, the TimesTen cache table and the cached Oracle table contain the following rows:

342 West Jane Stone
663 East  Pat Reed

The following row is inserted into the oratt.writetab TimesTen cache table:

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