Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL procedure
Define a sequence and use it in the "values" portion of your insert statement ("insert into t1 values ('aaa', 'bbb', seq_t1.nextval, ...)").
TRF
Marc Brevet Lepreux <mbl_at_concept.fr> a écrit dans l'article
<349E43C0.5BB055B2_at_concept.fr>...
> Hello
> I search a PL/SQL procedure for insert a lot off data in table with a
> primary key (id 0,1,2,..) in a loop.
> If you have an idea please help me
>
>
>
>
Received on Mon Dec 22 1997 - 00:00:00 CST