oracle自增列sequence

有一张表XINGSHI

create table XINGSHI
(
id NUMBER(20),
name VARCHAR2(100)
)

现在要求这一张表id序列自增，name需要insert.

1. 新建一个sequence
CREATE SEQUENCE emp_sequence
INCREMENT BY 1
START WITH 1
NOMAXVALUE
NOCYCLE
CACHE 10;

2. 利用sequence进行insert
INSERT into XingShi VALUES (emp_sequence.nextval,‘孟’);
INSERT into XingShi VALUES (emp_sequence.nextval,‘平’);
INSERT into XingShi VALUES (emp_sequence.nextval,‘黄’);
INSERT into XingShi VALUES (emp_sequence.nextval,‘和’);
INSERT into XingShi VALUES (emp_sequence.nextval,‘穆’);
INSERT into XingShi VALUES (emp_sequence.nextval,‘萧’);
INSERT into XingShi VALUES (emp_sequence.nextval,‘尹’);

拓展

–新建一个sequence
CREATE SEQUENCE emp_sequence
INCREMENT BY 1
START WITH 1
NOMAXVALUE
NOCYCLE
CACHE 10;

– 查询sequence当前值，每查询一次都会递增一次
select emp_sequence.nextval from dual;

–查询当前用户下的所有sequence
SELECT * FROM USER_SEQUENCES;

–删除 sequence
drop sequence emp_sequence;

–改变Sequence递增值
Alter sequence emp_sequence Increment By 3;