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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie question: Autonumber

Re: Newbie question: Autonumber

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Mon, 10 Feb 2003 20:56:24 +0100
Message-ID: <eu0g4v4l01js2ll1ve1h0iif2r8bvfq9ve@4ax.com>


On Mon, 10 Feb 2003 20:37:32 +0100, "Eirik Eldorsen" <eirikNOSPAM_at_eldorsens.nettsider.no> wrote:

>How can i create a coloumn in a table, that has an autogenerated uniqe
>number? Im connecting to a Oracle 8i server
>
>CREATE TABLE EMPLOYEE(
> EmployeeNr AUTONUMBER NOT NULL,
> Name VARCHAR2(50),
>CONSTRAINT EmployeeNr_pk PRIMARY KEY(EmployeeNr));

Look up 'sequences' in the Application Developer Manual.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Feb 10 2003 - 13:56:24 CST

Original text of this message

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