--更新工资后输出一句话createorreplacetrigger tri_test2
afterupdateon emp
for each rowdeclarebegin
dbms_output.put_line('更新了数据');end;--测试update emp set sal = sal+10
实例三–id自增长触发器
1.新建一个测试表
createtable person(
pid number primarykey,
pname varchar2(20))
2.创建一个序列
create sequence seq_person_pid;
3.创建触发器
createorreplacetrigger tri_add_person_pid
before
inserton person
for each rowdeclarebeginselect seq_person_pid.nextval into :new.pid from dual;end;
4.测试
insertinto person values(null,'aaa')select*from person