1、创建序列
1.1 创建序列:create sequence seqtest;
1.2 查询序列当前值:select seqtest.currval from dual;
1.3查询序列下一个值:select seqtest.nextval from dual;
1.4创建序列初始值为1,增副为1,循环|不循环:
create sequence testseq increment by 1 start with 1 maxvalue 99 cycle | nocycle;
2、修改序列
alter sequence testseq minvalue 0 | maxvalue 15;
3、删除序列
drop sequence testseq;
如对本文有疑问, 点击进行留言回复!!
Oracle 基本概念 Dadabase,schema,user,table...
dbeaver连接Oracle中文乱码的解决方案--druid
Oracle常用语句(时间格式、去重、去特殊符号、查询表空间等)
网友评论