CREATE SEQUENCE NEW_SEQUENCE start with 1 increment by 1 cache 100;
DROP SEQUENCE SEQUENCE_NAME;
SEQUENCE_NAME.NEXTVAL