Re: how to get more than ID value using nextval ???
From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 2 Jan 2003 09:22:57 -0800
Message-ID: <92eeeff0.0301020922.680dc904_at_posting.google.com>
Date: 2 Jan 2003 09:22:57 -0800
Message-ID: <92eeeff0.0301020922.680dc904_at_posting.google.com>
"Mohamed Badr" <mbm_1975_at_hotmail.com> wrote in message news:<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
Since you require a unique sequential id on every insert, you would have to use some process to generate it before inserting your value. I would stick with calling the sequence on every row insert....it's there for this reason.
Regards
/Rauf Sarwar
Received on Thu Jan 02 2003 - 18:22:57 CET