序列:就是自动设置序号的东西
索引:就是大数据量搜索时,优化搜索时间的
同义词:就是别名的意思,和试图的功能类似,就是一种映射关系。
CREATE TABLE student_temp(
id NUMBER(10),
sname VARCHAR2(10),
ssex varchar2(10),
tel NUMBER(10));
创建序列
CREATE SEQUENCE student_seq666666666
START WITH 10000
INCREMENT BY 1;
使用序列student.seq生成student_temp表中sid列插入值
INSERT INTO student_temp
VALUES (student_seq.nextval,'Scott','Science',11);
INSERT INTO student_temp
VALUES (student_seq.nextval,'SUPER MAN','COOKER',11);
查看student_sep序列当前值
SELECT student_seq.nextval FROM dual;
练习:
CREATE SEQUENCE dept_seq
START WITH 1
INCREMENT BY 1;
INSERT INTO dept
VALUES (dept_seq.nextval,'Education','DALLAS');
INSERT INTO dept
VALUES (dept_seq.nextval,'Market','WASHTON');