Oracle数据库如何创建自增序列?
程序员文章站
2022-12-10 15:32:40
-- 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'); <
上一篇: IOS APP制作二维码下载
下一篇: GreenPlum之日常SQL脚本笔记