Re: Sequence/Identity

From: Tony <andrewst_at_onetel.net.uk>
Date: 15 Jul 2004 07:50:18 -0700
Message-ID: <c0e3f26e.0407150650.538faff7@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

(No doubt as part of a large chorus): NO.

You can use a trigger to make the ID assignment happen "silently". Received on Thu Jul 15 2004 - 09:50:18 CDT