Home -> Usenet -> comp.databases.oracle -> insert and select in one statement

insert and select in one statement

From: Khurram Rao <khurramanis_at_hotmail.com>
Date: 10 Nov 2003 21:40:04 -0800
Message-ID: <5b60a892.0311102140.3476256f_at_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
_at__at_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
Received on Tue Nov 11 2003 - 06:40:04 CET












Original text of this message