主键在insert时由trigger调用sequence
生成CREATE TABLE test(
id number(18,0),
name varchar2(20));
CREATE sequence test_seq start with 1 increment by 1 nomaxvalue nocycle;
CREATE OR REPLACE TRIGGER test_trig_autoinc
BEFORE INSERT ON test
FOR EACH ROW
BEGIN
IF (:new.ID IS NULL) THEN
SELECT test_seq.nextval INTO :new.ID FROM DUAL;
END IF;
END;