Re: Oracle 8i

From: Peter Buzanits <>
Date: Mon, 02 Aug 1999 18:30:42 +0200
Message-ID: <>

GPVmbH wrote:

> I have create a table like adresse varchar2(20), str varchar2(20) and so on.
> In one field I want a number with the type long , which is unique like the
> field rowid.
> If I add a row the field must be one more than the last

You can use a sequence for that purpose. But it is not guaranteed, that the value is always exactly one more than the last... It's only guaranteed, that the value is unique.


DI Peter Buzanits
AOL-IM: Buzanits  Keys available on PGP-Servers
Received on Mon Aug 02 1999 - 18:30:42 CEST

Original text of this message