I am a new user to Oracle and I am trying to write a trigger with SQL PLUS.
I have an Oracle table with 25 fields, but want my trigger to fire when one of eight fields changes. I am trying to do this with a WHEN statement. Please help.
Is there a better way, this will not compile.

CREATE OR REPLACE TRIGGER OFFENDER_TRG
AFTER INSERT OR UPDATE ON OFFENDER
FOR EACH ROW
WHEN (NEW:ADDRESS <> OLD:ADDRESS)
OR (NEW:CITY <> OLD:CITY)
OR (NEW:STATE <> OLD:STATE)
OR (NEW:ZIP <> OLD:ZIP)
BEGIN
.....
END;