-- Create sequence
create sequence ONE_GRAM_ID minvalue 1 maxvalue 999999999999999999999999999 start with 1 increment by 1 cache 20 order;
---------------------------------------------------------------------
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;