create sequence NEXTNUMBER start with 1000 increment by 1 maxvalue 2000 nocycle cache 20;
insert into student ("NUMBER") values(nextNumber.nextval);
select * from student
insert into student ("NUMBER","NAME") values(nextNumber.nextval,nextNumber.nextval);