先创建一个序列:
create sequence seq1
start with 1
increament by 1;然后;
create trigger tri_on_ins
before insert
on table_name
for each row
begin
select seq1.nextval into :new.id;
end;
/
create sequence seq1
start with 1
increament by 1;然后;
create trigger tri_on_ins
before insert
on table_name
for each row
begin
select seq1.nextval into :new.id;
end;
/
先建表、再建序列、然后是触发器,最后测试=============================================
--为主键指定序列编号
--2003-10-8 15:53
============================================= conn scott/tiger@powermis drop table foo; create table foo(
id number primary key,
data varchar2(100)); create sequence foo_seq; create or replace trigger bifer_foo_id_pk
before insert
on foo
for each row
begin
select foo_seq.nextval into :new.id from dual;
end;
/ insert into foo(data)
values('Chirstopher'); insert into foo(id,data)
values(5,'Sean'); select * from foo;