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: <predditt_at_my-dejanews.com>
Date: Sat, 03 Oct 1998 02:24:00 GMT
Message-ID: <6v41rv$5g5$1@nnrp1.dejanews.com>


In article <6v0pse$qur_at_bgtnsc02.worldnet.att.net>,   "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!
>
>

Use a Sequence.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 02 1998 - 21:24:00 CDT

Original text of this message

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