Easy Learning... (Web Development,.NET Technology,Oracle,Silverlight,REST,SQL,Oracle,MySQL,Data Science, Python and many more ...)
SET Serveroutput ON
CREATE OR REPLACE TRIGGER log_salary
AFTER UPDATE ON emp
FOR EACH ROW
BEGIN
INSERT INTO Emp_log(Emp_id, Log_date, New_salary, Action)
VALUES (:NEW.Eno, SYSDATE, :NEW.Esalary, 'New Salary');
END;6
/
Thanks for showing your interestI will shortly get back to you
No comments:
Post a Comment
Thanks for showing your interest
I will shortly get back to you