Re: Datatype Question
From: Roger Wernersson <roger.wernersson_at_adra.se>
Date: 1996/12/09
Message-ID: <32ABF1DE.4BE5_at_adra.se>#1/1
Date: 1996/12/09
Message-ID: <32ABF1DE.4BE5_at_adra.se>#1/1
Lam Sze Wai wrote:
>
> Can anyone kindly tell me whether there exists a datatype
> that when a new record is added, its value automatically
> is increased by one? How can I access it using Pro*C?
You might want to use a sequence to handle the number and a trigger to insert a new value each time you insert a row in the tabel.
-- Sport radio: people listening to people watching people having fun Mailto:roger.wernersson_at_adra.se BTW: All opinions are mine, all mine, and nobody's but mine.Received on Mon Dec 09 1996 - 00:00:00 CET