oracle没有ORACLE自增字段这样的功能,但是通过触发器(trigger)和序列(sequence)可以实现。 假设关键字段为id,建一个序列,代码为: create sequence seq_test_ids minvalue 1 maxvalue 99999999 start with 1 increment by 1 nocache order; <!--[if !supportLineBreakNewLine]--> <!--[endif]-->
建解发器代码为: create or replace trigger tri_test_id before insert on test_table for each row declare nextid number; begin IF :new.id IS NULLor :new.id=0 THEN select seq_test_id.nextval into nextid from sys.dual; :new.id:=nextid; end if; end tri_test_id;