Apart from the fact that Oracle doesn't do auto-inserts?
actually it has to do with control. your before insert trigger can do a lot
more than just up a meaningless sequence number by a fixed amount.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Marcel Kraupp" <marcel.kraupp_at_gmx.ch> wrote in message
news:332bb004.0204290238.5d9f8de8_at_posting.google.com...
> > Create a sequence. Then use it in a before-insert trigger.
> >
> > Oracle, and I am so grateful, does not have autoinsert.
>
> 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?
>
> Marcel
Received on Mon Apr 29 2002 - 06:10:21 CDT
