CREATE SEQUENCE example_seq;
CREATE SEQUENCE example_seq
START WITH 300;
CREATE SEQUENCE example_seq
START WITH 300
INCREMENT BY 1
NOCACHE
NOCYCLE;
The first reference to example_seq.nextval returns 300. The second returns 301. Each subsequent reference will return a value 1 greater than the previous reference.