how to get more than ID value using nextval ???

From: Mohamed Badr <mbm_1975_at_hotmail.com>
Date: Thu, 02 Jan 2003 08:24:02 GMT
Message-ID: <CGSQ9.157904$F2h1.59524_at_news01.bloor.is.net.cable.rogers.com>


Hi all
I'm using proc/c++ to connect to oracle. the operation I wanna do is inserting 1000 record into a table. in case of single record, I used table_seq.nextval to get next ID. but I think there must be better way not to call it 1000 time. anybody has any idea ??? thanks
M.Badr Received on Thu Jan 02 2003 - 09:24:02 CET

Original text of this message