oracle的时序书的使用

create sequence student_sequence
       start with 10000
       increment by 1
--建立时序数

create table students(
       id number(5) primary key,
       first_name varchar2(20),      
       last_name varchar2(20),
       major varchar2(30),
       current_credits number(3)
);

--相应的表格

insert into students(id,first_name,last_name,major,current_credits)
values(student_sequence.nextval,'jessica','niu','medicine',0);

insert into students(id,first_name,last_name,major,current_credits)
values(student_sequence.nextval,'jessica','niu','medicine',0);

student_sequence.nextval相应的调用

select * from students;

1 10000 jessica niu medicine 0
2 10001 jessica niu medicine 0