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 -> Newbie question: Autonumber

Newbie question: Autonumber

From: Eirik Eldorsen <eirikNOSPAM_at_eldorsens.nettsider.no>
Date: Mon, 10 Feb 2003 20:37:32 +0100
Message-ID: <3e47ff7d$1@news.broadpark.no>


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));

--
Eirik Eldorsen
Received on Mon Feb 10 2003 - 13:37:32 CST

Original text of this message

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