Re: Is Sybase 'identity' column implemented in Oracle?
From: Gary Gapinski <gapinski_at_lerc.nasa.gov>
Date: 1996/06/28
Message-ID: <4r0g44$fnr_at_bytor.lerc.nasa.gov>#1/1
Date: 1996/06/28
Message-ID: <4r0g44$fnr_at_bytor.lerc.nasa.gov>#1/1
Hello, Carty:
Oracle allows the creation of a "sequence", which can be used as a source of unique numbers. Unfortunately, a sequence cannot be specified in a column default, so one must write a before-insert trigger to assign the value of a sequence to the "identity" column.
Regards,
Gary
-- __________________________________________________________ Gary Gapinski email: Gapinski_at_lerc.nasa.gov NASA Lewis Research Center voice: +1 216 433 5251Received on Fri Jun 28 1996 - 00:00:00 CEST