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: Simple Datatype Question

Re: Simple Datatype Question

From: TurkBear <johng_at_nospam.mm.com>
Date: Thu, 01 Oct 1998 21:17:01 GMT
Message-ID: <3613f101.16002610@news2.mm.com>


"Rob McElroy" <RobbieLee_at_Worldnet.att.net> wrote:

>Is their a field datatype in Oracle that is similar to Access's AutoNumber
>Datatype or SQL Servers Identity datatype?
>
>What I want is a field that generates a unique number for each new record.
>
>I realize this is an easy question, bear with me, I am learning the workings
>of Oracle.
>
>Thanks for your time!
>
>
>
>

You'll want to use an Oracle Sequence - check your docs for details on usage...

To reply please remove the 'nospam' part of the address Received on Thu Oct 01 1998 - 16:17:01 CDT

Original text of this message

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