先建一个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;