欢迎投稿

今日深度:

Oracle数据库如何创建自增序列?,oracle数据库

Oracle数据库如何创建自增序列?,oracle数据库


-- 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'); <

www.htsjk.Com true http://www.htsjk.com/oracle/24482.html NewsArticle Oracle数据库如何创建自增序列?,oracle数据库 -- Create sequence create sequence ID_SEQUENCE minvalue 1 maxvalue 9999999999999999999999999999 start with 100001 increment by 1 cache 1000; insert into 表名 values(ID_SEQUENCE....
评论暂时关闭