Re: ORACLE8: Automatic Counter Problem

From: Thomas Busl <thomas.busl_at_micromet.de>
Date: Fri, 16 Apr 1999 08:53:58 +0200
Message-ID: <3716DE86.AD96646@micromet.de>

Dear Magnus,
a possibility to solve your problem is using sequences. 1. Creating a sequence: create sequence example_seq

                                            start with 1 (or another value
you need)
                                            increment by 1 (or any other
value)
                                            NOMAXVALUE;

In your PL/SQL-Code use the sequence like this:

    select example_seq.nextval into tmpid from dual; tmpid holds no your counted value you can use in your table I hope it helps
so long
thomas

Magnus Lindhe wrote:

> Is it possible to have some kind of automatic counter data type in Oracle
> 8? If not, how can the same behaviour be solved by the developer?
>
> /magnus
Received on Fri Apr 16 1999 - 01:53:58 CDT