如查看名为“T_BPM_TASK_OPERATION_SEQ”的sequence:
- select * from user_sequences where sequence_name='T_BPM_TASK_OPERATION_SEQ'
所有建立的sequence 存放user_sequences中,属性有:SEQUENCE_NAME MIN_VALUE MAX_VALUE INCREMENT_BY CYCLE_FLAG ORDER_FLAG CACHE_SIZE LAST_NUMBER
修改sequence
- alter sequence T_BPM_TASK_OPERATION_SEQ increment by 1
Oracle中定义一个seq_test,最小值为10000,最大值为99999999999999999,从20000开始,增量的步长为1,缓存为20的循环排序Sequence:
create sequence seq_test
minvalue 10000
maxvalue 99999999999999999
start with 20000
increment by 1
cache 20
cycle
order;