From: khurramanis@hotmail.com (Khurram Rao)
Newsgroups: comp.databases.oracle
Subject: insert and select in one statement
Date: 10 Nov 2003 21:40:04 -0800
Organization: http://groups.google.com
Lines: 9
Message-ID: <5b60a892.0311102140.3476256f@posting.google.com>
NNTP-Posting-Host: 203.89.133.250
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1068529204 3381 127.0.0.1 (11 Nov 2003 05:40:04 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 11 Nov 2003 05:40:04 +0000 (UTC)


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