创建序列:create sequence SEQ
minvalue 1
maxvalue 999999999999999999999999999
start with 61
increment by 1
cache 30
order;使用:insert into tname values(SEQ.nextval,其他字段值)
minvalue 1
maxvalue 999999999999999999999999999
start with 61
increment by 1
cache 30
order;使用:insert into tname values(SEQ.nextval,其他字段值)
谢谢
建表
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;