and
using a table to simulate a sequence based on capabilities of the DB.
Ryan
From: Rick Hillegas rick.hille...@oracle.com
Subject: Re: Sequences as default values for a column
Hi Ryan,
I don't know whether you have considered identity columns. Identity columns
may give you what you need. See
Hi Ryan,
I don't know whether you have considered identity columns. Identity
columns may give you what you need. See the Derby Reference Guide topics
CREATE TABLE statement - column-definition -
generated-column-spec. Right now, identity columns provide less
concurrency than sequences do.
From what I can see in the Derby documentation, it's not possible to specify
the value of a sequence as the default value for a column. Is my reading of
this correct?
I've seen solutions online for Oracle, which also supports sequences, that
suggest using a before insert trigger to modify the