Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: integer column with auto increments

Re: integer column with auto increments

From: Wayne Menzie <waynem_at_bosmedtechdotcom.nospam>
Date: Wed, 26 Jan 2000 18:55:41 GMT
Message-ID: <8EC787085wayneshammalammading@129.250.35.141>


postmaster_at_sybrandb.nospam.demon.nl (Sybrand Bakker) wrote in <948900665.1338.0.pluto.d4ee154e_at_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.

Sybrand,

I think he wants the numbers to be in a continuous series. In a multiuser setting, a sequence won't give you that. At least, that's my understanding.

Wayne Received on Wed Jan 26 2000 - 12:55:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US