Re: How to update a column to its default value?

2 quick ways that I can think of.

1. Just update the LAST_UPDATE column at the same time as the text column. update DEFAULT_TABLE set TEXT = 'George', LAST_UPDATE = sysdate where TEXT = 'John';
2. Create an after update trigger for each row to update the LAST_UPDATE column whenever a record is updated.

I like option 1 better, only 1 statement involved. Received on Mon Apr 28 2003 - 12:50:10 CDT