Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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));
-- Eirik EldorsenReceived on Mon Feb 10 2003 - 13:37:32 CST
![]() |
![]() |