用trigger来自动做就行了 每次insert数据时候,调用trigger ,给你表的主键 select seq.nextval into :new.ID from dual
这个必须要使用触发器,要不你再插入数据的时候 insert table tablename values(seqname.value)我这里有个完整的例子,使用触发器 Oracle实现字段自动增长 序列: CREATE SEQUENCE myseq INCREMENT BY 1 START WITH 1 MAXvalue 1.0E28 MINvalue 1 NOCYCLE CACHE 20 NOORDER; 触发器: CREATE OR REPLACE TRIGGER mytrigger BEFORE INSERT ON mytable FOR EACH ROW begin Select myseq.Nextval into :New.ID From Dual; end;
每次insert数据时候,调用trigger ,给你表的主键 select seq.nextval into :new.ID from dual
insert table tablename values(seqname.value)我这里有个完整的例子,使用触发器
Oracle实现字段自动增长
序列:
CREATE SEQUENCE myseq INCREMENT BY 1 START WITH 1
MAXvalue 1.0E28 MINvalue 1 NOCYCLE
CACHE 20 NOORDER;
触发器:
CREATE OR REPLACE TRIGGER mytrigger BEFORE
INSERT ON mytable FOR EACH ROW begin
Select myseq.Nextval into :New.ID From Dual;
end;