sequence序列化常用命令

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;