--创建表
create table STU
(
s_id NUMBER(8) not null,
s_name VARCHAR2(20) not null,
s_sex VARCHAR2(8)
)
-- 创建序列 SEQ_TEST,从1开始,每次增加1
CREATE SEQUENCE SEQ_TEST
minvalue 1
maxvalue 99999999
start with 1
increment by 1
nocycle
nocache
order;
--查询序列的 下一个生成的序列号
select SEQ_TEST.nextval U_ID from dual;
--增加
INSERT INTO STU VALUES('8','捡子','男')
--删除
delete from STU where S_Id='7';
--修改
update STU SET S_NAME='张韬3' where S_Id='6';
update STU SET S_SEX='男' where S_Id='5';
--查
SELECT*FROM STU;
--自增插入成功
INSERT INTO STU(s_id,s_name,s_sex) VALUES(SEQ_TEST.nextval,'睡竹','竹');
--提交
commit;