Re: Newbie Question - AutoIncrement

From: George Ye <qiangye_at_my-deja.com>
Date: Tue, 14 Nov 2000 02:24:13 GMT
Message-ID: <8uq7oa$lb$1@nnrp1.deja.com>

Hi all,

How about SEQUENCE in Oracle? It might be helpful. The example is like:

CREATE SEQUENCE Order_seq
START WITH 1
INCREMENT BY 1
NOMAXVALUE
NOCYCLE
CACHE 20; INSERT INTO Orders_tab (Orderno, Custno) VALUES (Order_seq.NEXTVAL, 1032);

George

In article <974147124.6818.0.nnrp-01.9e984b29_at_news.demon.co.uk>, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
> The quick answer is no.
> There is an article on my website (under the FAQ)
> section describing the typical Oracle method to meet
> this requirement.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 13 2000 - 20:24:13 CST