查询SEQUENCES的最大值:
SELECT LAST_NUMBER FROM USER_SEQUENCES WHERE SEQUENCE_NAME='S_IBACCOUNT';
删除SEQUENCES:
DROP SEQUENCE S_IBACCOUNT;
新建SEQUENCES:
create sequence S_IBACCOUNT increment by 1 start with 1 maxvalue 999999999;
查询SEQUENCES的最大值:
SELECT LAST_NUMBER FROM USER_SEQUENCES WHERE SEQUENCE_NAME='S_IBACCOUNT';
DROP SEQUENCE S_IBACCOUNT;
新建SEQUENCES:
create sequence S_IBACCOUNT increment by 1 start with 1 maxvalue 999999999;