写作缘由:
会籍管理+部门管理 bug
参考文献:
https://blog.csdn.net/zhch152/article/details/7747571
用到的命令有:
删除序列号
DROP SEQUENCE SYS_P_DEPARTMENT_SEQ;
创建序列号
CREATE SEQUENCE SYS_P_DEPARTMENT_SEQ
INCREMENT BY 1 -- 每次加几个
START WITH 100 -- 从1开始计数
MAXVALUE 9999999999999999999999999999 -- 不设置最大值
NOCYCLE -- 一直累加,不循环
CACHE 10;
修改序列号增加值
UPDATE USER_SEQUENCES
set LAST_NUMBER=47
WHERE SEQUENCE_NAME='SYS_P_DEPARTMENT_SEQ'
使用并查询下一个序号
select SYS_P_DEPARTMENT_SEQ.nextVal from dual
select SYS_P_DEPARTMENT_SEQ.nextVal from dual@whgh_dblink;
当前的序列号
select SYS_P_DEPARTMENT_SEQ.currval from dual@whgh_dblink;
默认递增查询序列号到哪里了
SELECT ID from SYS_P_DEPARTMENT@whgh_dblink;
问题:这个的返回值我有点难以置信。它返回就一个值
select * from dual
查询上一个到哪里了
Select LAST_NUMBER from user_sequences WHERE SEQUENCE_NAME='SYS_P_DEPARTMENT_SEQ';
-- conn tt@whgh_dblink;
查看创建的所有的序列号
-- SELECT SEQUENCE_NAME,MIN_VALUE,MAX_VALUE,INCREMENT_BY,LAST_NUMBER FROM
-- USER_SEQUENCES;