CREATE SEQUENCE customers_seq
START WITH 1000
INCREMENT BY 1
NOCACHE
NOCYCLE;
CREATE OR REPLACE TRIGGER JOB_INSTANCE_BRI
BEFORE INSERT ON JOB_INSTANCE
FOR EACH ROW
BEGIN
SELECT JOB_INSTANCE_SEQ.nextval INTO :new.JOBINSTANCEID FROM dual;
END;
DROP SEQUENCE HIBERNATE_SEQUENCE;
CREATE SEQUENCE "HIBERNATE_SEQUENCE" INCREMENT BY 1 START WITH 1000 CACHE 100 NOORDER NOCYCLE;
select HIBERNATE_SEQUENCE.nextval from dual
grant SELECT ON HIBERNATE_SEQUENCE to ROLE;
https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_6015.htm