如何返回当前id值,sql该怎么写呢?

[zdnetchina]

表a有个主键id

id通过序列来递增

CREATE SEQUENCE SafeResult_sequence
INCREMENT BY 1　 -- 每次加几个
START WITH 1　　 -- 从1开始计数
NOMAXVALUE　　　 -- 不设置最大值
NOCYCLE　　　　　-- 一直累加，不循环
CACHE 10;

当我插入一条记录并返回它的id,sql该怎么写呢?

[sasacat]

insert into t(id,name,...) values(seq1.nextval,....) return id into v_id;
然后以v_id 查询即可：
select * from t where id=v_id;

[沝林]

1.select SafeResult_sequence.currval from dual;

2.也可以用
insert into a(id,field1...) values(SafeResult_sequence.nextval,12...)
returning id into pnum;

[zdnetchina]

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 就放在这个变量里啊

[zdnetchina]

执行 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
----------
10001

SQL> select linenum.currval from dual;

CURRVAL
----------
10001