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: how to use a sequence?

Re: how to use a sequence?

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 24 Apr 2004 12:55:34 +1000
Message-ID: <4089d721$0$12481$afc38c87@news.optusnet.com.au>


Eric Lee wrote:
> I have created a sequence named idx.
> How can I use this sequence when I create a table?
> I wanna create a table with primary key which can auto increment.
>
>
> thanks advance.

You might want to refer to the Basic Administration FAQ at www.dizwell.com. There is an entire section devoted to auto-incrementing columns there.

Regards
HJR Received on Fri Apr 23 2004 - 21:55:34 CDT

Original text of this message

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