Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Autoincrement in Oracle 8.1.7

Re: Autoincrement in Oracle 8.1.7

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Mon, 29 Apr 2002 21:06:02 +1000
Message-ID: <3ccd2a12$0$15476$afc38c87@news.optusnet.com.au>


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.nospam
Received on Mon Apr 29 2002 - 06:06:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US