insert and select in one statement

[Khurram Rao]

using MS Sql server and VB i can execute two queries Insert and select
in one statement e.g. (insert into (....) values (...) Select
@@Identity).
how can i do the same thing using Oracle and VB. ???
It gives error. here's what i want to do.
(insert into table1 (...) values (...) Select table1_sequence.currval
from dual )

Khurram

[sybrandb]

kh*********@hotmail.com (Khurram Rao) wrote in message news:<5b**************************@posting.google. com>...

using MS Sql server and VB i can execute two queries Insert and select
in one statement e.g. (insert into (....) values (...) Select
@@Identity).
how can i do the same thing using Oracle and VB. ???
It gives error. here's what i want to do.
(insert into table1 (...) values (...) Select table1_sequence.currval
from dual )

Khurram

insert into table
select .... from dual;

And also you shouldn't use currval, but nextval
and lookup mere syntax questions in the sql reference manual at
http://tahiti.oracle.com.
Yes, I am very well aware people exposed to sqlserver NEVER read
manuals.

Sybrand Bakker
Senior Oracle DBA