Oracle Trigger Updating a field in Insert or Update

Question

For some reason, I am launching a space on how to do something like this.

I have a table that looks like this:

UserID | Name | DateAdded | LastUpated -------------------------------------------------- 1 | James Q | 1/1/2009 | 

If I insert or update a record, the latest update should be updated by sysdate. How can I do something like this?

Answer 1

 CREATE OR REPLACE TRIGGER your_trigger_name BEFORE INSERT OR UPDATE ON your_table FOR EACH ROW DECLARE BEGIN :new.LastUpdated := sysdate; END; 

Give it a try. I did not have an oracle server at hand, but I hope I got the correct syntax.

Answer 2

create or replace mytable_bi trigger before inserting on the table for each row start

: NEW.lastupdated: = sysdate ();

end;

create or replace mytable_bu trigger before updating to mytable for each row start

: NEW.lastupdated: = sysdate ();

end;