2015年1月6日19:21:02
1.创建表
create table tbl_user(userId integer primary key,
name varchar2(20)
);
2.创建序列
create sequence seq_user start with 1 increment by 1;3.创建触发器
create or replace trigger tri_userbefore insert on tbl_user
for each row
begin
select seq_user.nextval into :new.userId from dual;
end;
4.添加数据
insert into tbl_user(name) values ('cc');insert into tbl_user(name) values ('dd');
commit;
5.查询数据
select * from tbl_user;
参考文章出自这里!!!