从插入语句返回值 [英] Return a value from a insert statement

问题描述

使用OLEDB从ASP.NET 2.0(VB)应用程序处理Oracle 9i数据库.有没有一种方法可以让插入语句返回一个值?我将序列号设置为进入数据库的数字条目，但是我需要在插入后返回该值，以便可以对刚刚在VB背后的代码中输入的集合进行一些操作.

Working with an Oracle 9i database from an ASP.NET 2.0 (VB) application using OLEDB. Is there a way to have an insert statement return a value? I have a sequence set up to number entries as they go into the database, but I need that value to come back after the insert so I can do some manipulation to the set I just entered in the code-behind VB.

推荐答案

一些可能性:

1)使用RETURNING子句:

1) Use the RETURNING clause:

INSERT INTO emp (empno, ename) VALUES (emp_seq.NEXTVAL, 'ANDREWS')
RETURNING empno INTO :variable;

2)使用序列CURRVAL:

2) Use the sequence CURRVAL:

INSERT INTO emp (empno, ename) VALUES (emp_seq.NEXTVAL, 'ANDREWS');
SELECT emp_seq.CURRVAL INTO :variable FROM DUAL;

CURRVAL返回您的会话生成的最后一个序列值.

CURRVAL returns the last sequence value generated by your session.

这篇关于从插入语句返回值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！