用序列和触发器:
CREATE SEQUENCE TEST_ID_SEQ minvalue 0 start with 0 increment by 1 /
CREATE OR REPLACE TRIGGER TEST_INS_TRG
BEFORE INSERT ON TEST
FOR EACH ROW
BEGIN SELECT client_id_seq.nextval INTO :new.id FROM dual;
END; /
CREATE SEQUENCE TEST_ID_SEQ minvalue 0 start with 0 increment by 1 /
CREATE OR REPLACE TRIGGER TEST_INS_TRG
BEFORE INSERT ON TEST
FOR EACH ROW
BEGIN SELECT client_id_seq.nextval INTO :new.id FROM dual;
END; /
http://expert.csdn.net/Expert/topic/1188/1188814.xml?temp=.4737207这个问题一天要提80遍呐
create sequence test start with 1 increment by 1
用test.nextval 就可以了