select sequence.currval 时报错 ORA-08002: 序列XXXX尚未在此进程中定义
来源:互联网 发布:网络加速器哪个好用 编辑:程序博客网 时间:2024/05/22 10:24
情景描述:
1.我们创建一个表,表名为S_DEPART
-- Create tablecreate table S_DEPART( departid INTEGER not null, departname NVARCHAR2(40) not null, departorder INTEGER default 0)2.创建一个sequence序列,名称为S_DEPART_S
CREATE SEQUENCE S_DEPART_S MINVALUE 1MAXVALUE 9999999999999999999999START WITH 1INCREMENT BY 1NOCACHE;3.下面我们往该表里插入一条记录
insert into S_Depart(departid,Departname,Departorder)VALUES(S_DEPART_S.CURRVAL,'12345',1);此时,出现如下错误:
报错 ORA-08002: 序列XXXX尚未在此进程中定义
错误分析:sequence序列的CURRVAL必须要先用NEXTVAL初始化一下,以后就可以用CURRVAL了。
解决办法:先用NEXTVAL初始化:
<pre name="code" class="sql">insert into S_Depart(departid,Departname,Departorder)VALUES(S_DEPART_S.NEXTVAL,'12345',1);此时我们可以查询sequence序列S_Depart_s的值:
SELECT S_DEPART_S.CURRVAL FROM dual;从下图我们可以看到S_Depart_s序列的当前值为2
0 0
- select sequence.currval 时报错 ORA-08002: 序列XXXX尚未在此进程中定义
- ORA-08002错误:序列 XXXX.CURRVAL 尚未在此会话中定义
- ORA-08002 序列XXXX尚未在此进程中定义
- ORA-08002:序列XXXXXXX.CURRVAL尚未在此进程中定义
- Oracle 序列使用时:ORA-08002: 序列 SEQ_WGB_TEST2.CURRVAL 尚未在此会话中定义
- ORA-08002: 序列 SEQ_WGB_TEST2.CURRVAL 尚未在此会话中定义
- ORA-08002: 序列 SEQ_GX.CURRVAL 尚未在此会话中定义
- ORA-08002: 序列 SEQ_WGB_TEST2.CURRVAL 尚未在此会话中定义
- ORA-08002: 序列 SEQ1.CURRVAL 尚未在此会话中定义
- 编译caffe时报错memcpy在此作用域中尚未申明
- ORA-08002: SEQUENCES **.CURRVAL 未定义
- Oracle/PLSQL ORA-08002: sequence NAME.CURRVAL is not yet defined in this session
- ORA-08002: sequence s%.CURRVAL is not yet defined in this session
- ORA-08002: sequence TEST1.CURRVAL is not yet defined in this session
- ORA-08002: sequence CURRVAL is not yet defined in this session
- ORA-08002: sequence SEQ_PREPAY.CURRVAL is not yet defined in this session的原因
- ORA-08002: sequence CURRVAL is not yet defined in this session
- ORA-08002: sequence SEQ_TBL_ONLINE.CURRVAL is not yet defined in this session
- Search a 2D Matrix
- 输入一
- JsPlumb 基本使用方法( JsPlumb & JQ ContextMenu & JQ Dialog)
- Linux帮助命令
- onmousemove、onmouseover、 onmouseup及onclick的区别
- select sequence.currval 时报错 ORA-08002: 序列XXXX尚未在此进程中定义
- HDU 4628 Pieces (状压DP)
- Java IO学习【9】模拟一个Buffer-MyBufferedReader
- 防止 Chrome 屏蔽 非官方 扩展程序
- object c中 new和alloc区别
- 输入二
- 欢迎使用CSDN-markdown编辑器
- HDU 4568 旅行商问题
- HDU 3853