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();
pro_trail(){
BEGIN
NEW.modified_date=(select current_timestamp)
return NULL;
END;
}
Can anybody help me out!!!
Mandar M. Bhosale