creating triggers?

[John Brittingham]

I would like to create a trigger that either updates or inserts a row in
my USERS_PER_HOUR table when an entry is made in the LOG table. 

The log table has LOG_DATE, LOG_TIME and a CUID columns that I would
like to either create a new row if the LOG_DATE and LOG_TIME do not
exist or update the number of CUIDS for that date and time if it does. 

I have never done anything with triggers and wonder if this is possible?

 

John Brittingham

Marketing and Customer Systems 

Desk: 425-288-8071

Cell: 425-770-0458