PLSQL5_触发器的.pptVIP

PL/SQL语言;本章内容;触发器;DML触发器;before;after;行级别触发器中的相关标识符;语句触发;触发器谓词;替代触发器;替代触发器;例子;例子;系统触发器;系统触发器;DDL触发器;启动/禁用/删除触发器;一个例子（对还是错？）;动态SQL;动态SQL;修改成以下代码（对还是错？）;正确写法(一);正确写法(二);Oracle自增字段(列)的实现 ;;drop table itest; create table itest ( id number(9) primary key, name varchar2(10) not null, age number(2));drop sequence seq_itest_id;create sequence seq_itest_id;drop trigger itest_id_trigger;create trigger itest_id_trigger before insert on itest for each row begin select seq_itest_id.nextval into :new.id from dual; end;/insert into itest(name,age) values(Scott,25);insert into itest(name,age) values(Sarah,24);insert into itest(name,age) values(Billy,33);-- Ok, lets see what we got in our tableselect * from itest;ID NAME AGE---------- ---------- ----------1 Scott 252 Sarah 243 Billy 33 ;NOCOPY编译器暗示（8i）