From: joiey.seeley@gmail.com   
      
   I'm trying to create a before insert or update trigger that would update a   
   timestamp any time an update is made to a table.  The following is my query,   
   but this is giving an invalid SQL statement error.   
      
   CREATE OR REPLACE TRIGGER "SCHEMA".TRIGGER_NAME"   
   BEFORE INSERT OR UPDATE ON SCHEMA.TABLENAME   
   FOR EACH ROW   
   BEGIN   
           :new.LASTMODIFIED := sysdate;   
   END;   
   /   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)