Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Autonumbers in Oracle
I'll vote for triggers too. Saves programming effort (don't have to
explicitly reference the field in update and insert statements),
and insert..selects don't seem to be (newbie observation, 8i) possible
without them, eg.
insert into newtab
select newtab_seq.nextval,other fields from oldtab;
will give you a syntax error.
"Irek Konefal" <i.konefal_at_m.cc.utah.edu> wrote in message
news:aamjlj$17q$1_at_coward.ks.cc.utah.edu...
> Which is the better method (and why) for generating Autonumbers in Oracle:
> Sequence/Nextval called from front-end or Sequence/Trigger called from
Dual
> at the back-end?
>
> Thanks much - Irek
>
>
Received on Wed May 01 2002 - 08:19:16 CDT