create or replace trigger print_salary_changes
before delete or insert or update on Emp
for each row
declare
sal_diff varchar2(20);
begin
sal_diff:=:new.sal-:old.sal;
dbms_output.put('old salary:'||:old.sal);
dbms_output.put('new salary:'||:new.sal);
dbms_output.put_line('DIFFERENCE'||sal_diff);
end;
/
before delete or insert or update on Emp
for each row
declare
sal_diff varchar2(20);
begin
sal_diff:=:new.sal-:old.sal;
dbms_output.put('old salary:'||:old.sal);
dbms_output.put('new salary:'||:new.sal);
dbms_output.put_line('DIFFERENCE'||sal_diff);
end;
/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货