oracle ID 自动增长

-- Create sequence 

create sequence ONE_GRAM_IDminvalue 1maxvalue 999999999999999999999999999start with 1increment by 1cache 20order;
---------------------------------------------------------------------
CREATE OR REPLACE TRIGGER BeforeONE_GRAMInsert
BEFORE INSERT ON ONE_GRAM
FOR EACH ROW
BEGIN
SELECT ONE_GRAME_ID.nextval  INTO :new.id  FROM dual;
END;