Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Autoincrement in Oracle 8.1.7
In article <332bb004.0204290238.5d9f8de8_at_posting.google.com>, you said
(and I quote):
> Obviously (from this ng at least), everyone working on Oracle
> seems to prefer "before insert triggers" over autoinserts.
>
> What is the specific reason for that?
Because you can do all changes to the new row before actually writing it. Assuming you want to change it before writing, which is what generating an ID with sequences is all about. Otherwise you'd have to do an UPDATE?
-- Cheers Nuno Souto nsouto_at_optushome.com.au.nospamReceived on Mon Apr 29 2002 - 06:06:02 CDT