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