Re: integer column with auto increments

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Wed, 26 Jan 2000 16:29:08 +0100
Message-ID: <948900665.1338.0.pluto.d4ee154e@news.demon.nl>

Use a sequence for this and call select sequence.nextval into count1 from dual in a pre-insert trigger. Has been explained in detail in the newsgroups the last few days.

Hth,

--
Sybrand Bakker, Oracle DBA
<screwbai_at_my-deja.com> wrote in message news:86mv31$9p1$1_at_nnrp1.deja.com...
> I have a table like this
>
> count1 value1
> 1 6
> 2 4
> 3 6
> 4 8
>
> For each new value in the column value1 I insert I want a counter in the
> count1 column to follow it along.
>
> Does anyone know a simple solution to this.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Received on Wed Jan 26 2000 - 09:29:08 CST