View Single Post
  #9 (permalink)  
Old June 14th, 2004, 11:12 PM
junemo junemo is offline
Authorized User
 
Join Date: Apr 2004
Location: malacca, malacca, Malaysia.
Posts: 69
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to junemo
Default

Thanks Justin.

I want insert new field- in_line into table ITEM, defined as PRIMARY KEY and auto increment. How do I write the SQL script?

Isn't like this:

CREATE TABLE item (
   in_line NUMBER CONSTRAINT pk_item PRIMARY KEY AUTO INCREMENT,
   line NUMBER,
   <<more columns>>
);

Thanks in advance.