Figure 4a – Hidden timestamp code

 

CREATE TABLE tickets(ticket_ord INTEGER,

                     ticket_qty INTEGER,

                     ticket_event VARCHAR(10),

                     ticket_ts TIMESTAMP NOT NULL

                               IMPLICITLY HIDDEN

                               FOR EACH ROW ON UPDATE

                               AS ROW CHANGE TIMESTAMP);



INSERT INTO tickets VALUES(1,11,'mvGAME1'), (2,8,'ihGAME4');



SELECT * FROM tickets;



UPDATE tickets SET ticket_qty = 6 WHERE ticket_ord = 2;



SELECT ticket_ord, ticket_qty, ticket_event,

       ticket_ts FROM tickets;