Chapter 18: Cursors: Accessing Data

Timestamping an existing table

To prepare an existing table for browsing, add a column named timestamp with alter table. For example:

alter table oldtable add timestamp

A timestamp column with a null value is added to each existing row. To generate a timestamp, update each row without specifying new column values.

For example:

update oldtable
set col1 = col1