Re: Oracle 8i
From: Peter Buzanits <peter_at_icb.co.at>
Date: Mon, 02 Aug 1999 18:30:42 +0200
Message-ID: <37A5C7B2.E950ACBB_at_icb.co.at>
Date: Mon, 02 Aug 1999 18:30:42 +0200
Message-ID: <37A5C7B2.E950ACBB_at_icb.co.at>
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.
Peter
-- ----------------------------------------------- DI Peter Buzanits mailto:peter_at_icb.co.at http://peter.icb.at AOL-IM: Buzanits Keys available on PGP-Servers -----------------------------------------------Received on Mon Aug 02 1999 - 18:30:42 CEST