Oracle数据库如何创建自增序列?
程序员文章站
2022-05-25 12:30:15
-- Create sequence
create sequence ID_SEQUENCE
minvalue 1
maxvalue 99999999999999999999...
-- Create sequence
create sequence ID_SEQUENCE
minvalue 1
maxvalue 9999999999999999999999999999
start with 100001
increment by 1
cache 1000;
insert into 表名 values(ID_SEQUENCE.Nextval,'**','PICC0100001'); <