创建触发器 (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);