Befor update of MGR,EMPNO on EMP
426349Jul 28 2004 — edited Jul 29 2004Hi,
Please help me for this problem:
create or replace trigger emp_before
before update of MGR,EMPNO on emp for each row
begin
If updating ?????MGR??? then
('EMP','MGR',:old.MGR,:new.MGR);
elsif updating ?????empno??? then
('EMP','EMPNO',:old.empno,:new.empno);
end if;
end;
Actual syntax in place of ????MGR??? and ???empno????
Thanks & Regards