I have difficulty in setting a trigger to have
trail of my project
I need to update the modified_date of my database
tables through trigger as
CREATE OR REPLACE TRIGGER taril_trigger AFTER
UPDATE ON test_trigger FOR EACH ROW
EXECUTE PROCEDURE pro_trail();
EXECUTE PROCEDURE pro_trail();
pro_trail(){
BEGIN
NEW.modified_date=(select current_timestamp)
return NULL;
END;
}
BEGIN
NEW.modified_date=(select current_timestamp)
return NULL;
END;
}
Can anybody help me out!!!
Mandar M. Bhosale
