创建触发器
(1) 创建表
create table stu(
name VARCHAR(10),
sex number(1),
phone varchar(11)
);
(2) 创建触发器
create or replace trigger t_myDemo
before insert
on str
for each row
begin
update str set sex=0 where name = 'XXX';
end;
(3)触发触发器
insert into stu values ('XXX',1,1509993030);