1.select SafeResult_sequence.currval from dual;2.也可以用 insert into a(id,field1...) values(SafeResult_sequence.nextval,12...) returning id into pnum;
执行 select SafeResafsult_sequence.currval from dual;ORA-02289: 序列(号)不存在
执行 select SafeResafsult_sequence.currval from dual;ORA-02289: 序列(号)不存在 __________________________________________执行这个语句要在取到nextval之后进行,也就是insert之后SQL> select linenum.currval from dual; select linenum.currval from dual * ERROR 位于第 1 行: ORA-08002: 序列LINENUM.CURRVAL 尚未在此进程中定义 SQL> select linenum.nextval from dual; NEXTVAL ---------- 10001SQL> select linenum.currval from dual; CURRVAL ---------- 10001
to: duanzilin(寻)
insert into a(id,field1...) values(SafeResult_sequence.nextval,12...) returning id into pnum; ----------------------------------------returning id into pnum; pnum是什么?id写到什么地方去了.执行后出现 ORA-00905: 缺少关键字
insert into a(id,field1...) values(SafeResult_sequence.nextval,12...) returning id into pnum; ---------------------------------------------- pnum是你在pl/sql中定义的变量,id 就放在这个变量里啊
insert into a(id,field1...) values(SafeResult_sequence.nextval,12...)
returning id into pnum;
__________________________________________执行这个语句要在取到nextval之后进行,也就是insert之后SQL> select linenum.currval from dual;
select linenum.currval from dual
*
ERROR 位于第 1 行:
ORA-08002: 序列LINENUM.CURRVAL 尚未在此进程中定义
SQL> select linenum.nextval from dual; NEXTVAL
----------
10001SQL> select linenum.currval from dual; CURRVAL
----------
10001
insert into a(id,field1...) values(SafeResult_sequence.nextval,12...)
returning id into pnum;
----------------------------------------returning id into pnum; pnum是什么?id写到什么地方去了.执行后出现 ORA-00905: 缺少关键字
returning id into pnum;
----------------------------------------------
pnum是你在pl/sql中定义的变量,id 就放在这个变量里啊