先建一个sequence,再建一个trigger,然后在Insert语句中你就不用在理这个自动增长的字段了。 example: 1:sequence: CREATE SEQUENCE seq_TlogList start with 1 increment by 1; 2: trigger: CREATE OR REPLACE TRIGGER tr_TlogList_Insert BEFORE INSERT ON TlogList FOR EACH ROW BEGIN SELECT seq_TlogList.nextval INTO :new.serial_no FROM dual; END tr_TlogList_Insert;一切OK了。
CREATE sequence addid1 increment by 1 START WITH 1;
得到当前的序号:
select addid1.currval from dual ;
得到下一个序号:
select addid1.nextval from dual ;
insert into dept values(seq1.nextval,...) ;
to(心雨):重建序列规0.或者创建循环序列,到max值之后自动从min值开始
example:
1:sequence:
CREATE SEQUENCE seq_TlogList start with 1 increment by 1;
2: trigger:
CREATE OR REPLACE TRIGGER tr_TlogList_Insert
BEFORE INSERT ON TlogList
FOR EACH ROW
BEGIN
SELECT seq_TlogList.nextval
INTO :new.serial_no
FROM dual;
END tr_TlogList_Insert;一切OK了。