sequence序列化常用命令

最新推荐文章于 2022-12-14 07:48:35 发布

蘑菇丁

最新推荐文章于 2022-12-14 07:48:35 发布

阅读量958

点赞数

分类专栏：学习笔记

本文链接：https://blog.csdn.net/haoxiaoyan/article/details/16953123

版权

学习笔记专栏收录该内容

68 篇文章 2 订阅

订阅专栏

1、查看当前sequence值
select seq_no_retailer_inv.nextval from dual;
2、修改最大值
alter sequence SEQ_NO_RETAILER_INV maxvalue 99999999999999999999999999999
3、创建sequence
create sequence "EBRIDGE_VSENS_16"."SEQ_NO_RETAILER_INV"
minvalue 0
maxvalue 9999999999999999999999999999
start with 10
increment by 1
cache 20
NOORDER NOCYCLE ;
4、赋予相应的权限
GRANT ALTER ON "EBRIDGE_VSENS_16"."SEQ_NO_RETAILER_INV" TO "YXUSER_TEST";

GRANT SELECT ON "EBRIDGE_VSENS_16"."SEQ_NO_RETAILER_INV" TO "YXUSER_TEST";
select fun_get_busi_no_regi('CF0500') from dual

5、删除sequence
DROP SEQUENCE SEQ_NO_RETAILER_INV

6、查看sequence
select * from user_sequences t order by t.sequence_name;