查询指定sequence的当前值:SELECT LAST_NUMBER FROM USER_SEQUENCES WHERE SEQUENCE_NAME='SEQ_KHW_NO'
sequence 存储在数据字典中,存储于user_sequences表 LAST_NUMBER 为最终序列号,也就是sequence游标当前所在的位置。
select sequence_name, max_value, increment_by, last_number from user_sequences
查询指定sequence的当前值:SELECT LAST_NUMBER FROM USER_SEQUENCES WHERE SEQUENCE_NAME='SEQ_KHW_NO'
sequence 存储在数据字典中,存储于user_sequences表 LAST_NUMBER 为最终序列号,也就是sequence游标当前所在的位置。
select sequence_name, max_value, increment_by, last_number from user_sequences