Re: Sequence/Identity

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 15 Jul 2004 08:15:13 -0700
Message-ID: <2687bb95.0407150715.7f489694@posting.google.com>

"Ernest Morariu" <ernest_at_gesora.com> wrote in message news:<cd5kph$fnm$1_at_carabinieri.cs.interbusiness.it>...
> Hi All!
>
> It is possible in Oracle 8i to define a column(called ID) in a table as been
> value-autogenerated or Identity(as in SqlServer)?
>
> Is there any alternative to the sequences for generating the new IDs for my
> tables ?
>
> Ernest

Ernest, create a before insert trigger on the table and insert the sequence_nam.nextval there.

You can find an article on this topic at the cooperative FAQ hosted by Jonathan Lewis at http://www.jlcomp.demon.co.uk/faq

HTH -- Mark D Powell -- Received on Thu Jul 15 2004 - 10:15:13 CDT