Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie question: Autonumber
> 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 todayReceived on Mon Feb 10 2003 - 14:10:55 CST