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: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 10 Feb 2003 20:10:55 GMT
Message-ID: <b2910f$198cia$1@ID-82536.news.dfncis.de>

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

http://makeashorterlink.com/?Y33435A63

hth
Rene Nyffenegger

-- 
  no sig today
Received on Mon Feb 10 2003 - 14:10:55 CST

Original text of this message

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