1、创建表时将Infrom_ID列设置为主键列;创建序列seq。 2、插入数据时候可以有两种方式: 1)直接插入序号 insert into ELE_Infrom (Infrom_ID,Infrom_CreateUserID,...) values(seq.nextval,1000001,...);2)创建触发器自动插入序号 create or replace trigger trg_test before insert on ELE_Infrom for each row begin select seq.nextval into :new.Infrom_ID from dual ; end trg_test; insert into ELE_Infrom (Infrom_CreateUserID,...) values(1000001,...);
1、创建触发器 create sequence seq minvalue 1 ----最小值 maxvalue 99999999999999 ----最大值 start with 1 ----起始值 increment by 1 ----增量 cache 20;
2、插入数据时候可以有两种方式:
1)直接插入序号
insert into ELE_Infrom (Infrom_ID,Infrom_CreateUserID,...) values(seq.nextval,1000001,...);2)创建触发器自动插入序号
create or replace trigger trg_test
before insert on ELE_Infrom
for each row
begin
select seq.nextval into :new.Infrom_ID from dual ;
end trg_test; insert into ELE_Infrom (Infrom_CreateUserID,...) values(1000001,...);
create sequence seq
minvalue 1 ----最小值
maxvalue 99999999999999 ----最大值
start with 1 ----起始值
increment by 1 ----增量
cache 20;