CREATE OR REPLACE TRIGGER DOC_TEST_TRI before update of deleted ,receiveDate on DOC_TEST for each rowbegin :new.syncflag:=0;end;