Re: Sequence/Identity

From: Ed prochak <ed.prochak_at_magicinterface.com>
Date: 15 Jul 2004 10:29:17 -0700
Message-ID: <4b5394b2.0407150929.77a6eba8@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

IN ORACLE you create a sequence and use it via a trigger. That's just the way it is.

The real question is, Do you have good reasons for using a pseudo-key for your tables? As Joe Celko in comp.databases might say: are you building a Relational Database, or a file server? Received on Thu Jul 15 2004 - 12:29:17 CDT