--Sequencen

create sequence seq_SEQUENCENAME
minvalue 0
maxvalue 999999999999999999999999999
start with 1
increment by 1
order;


select seq_SEQUENCENAME.nextval from dual;