1.创建表
create table student(
id number(19) not null,
name varchar2(20),
sex number(2),
primary key(id)
)
2.创建序列
create sequence s_student
increment by 1
start with 1
nomaxvalue
nocycle
nocache
3.插入若干条数据
insert into student values(s_student.nextval, 'student001', 0);
insert into student values(s_student.nextval, 'student002', 0);
insert into student values(s_student.nextval, 'student003', 0);
insert into student values(s_student.nextval, 'student004', 0);
insert into student values(s_student.nextval, 'student005', 0);
4.复制数据并插入当前表的语句 insert into student select s_student.nextval, student.name, student.sex from student;