Oracle自增序列
时间:2022-03-10 17:52
//创建自增序列
create sequence SEQ
increment by 1
start with 0
nomaxvalue
minvalue 0
nocycle;
//在sql中使用该序列
INSERT INTO USERS VALUES (SEQ.nextval,‘Username‘,‘Password‘,‘Sex‘,‘Xl‘);
Oracle自增序列,布布扣,bubuko.com
时间:2022-03-10 17:52
//创建自增序列
create sequence SEQ
increment by 1
start with 0
nomaxvalue
minvalue 0
nocycle;
//在sql中使用该序列
INSERT INTO USERS VALUES (SEQ.nextval,‘Username‘,‘Password‘,‘Sex‘,‘Xl‘);
Oracle自增序列,布布扣,bubuko.com