I just wanted to know how can I have a Primary Key be an Auto number. In Access you can specify it to be a auto number and so it just increases with each record added. How can I do that in oracle. For Example
CREATE TABLE TEST
tableID NUMBER(6) not null,
CONSTRAINT tableID_pk PRIMARY KEY (tableID));
so How can I have tableID increase it self with each record added.
Thanks in advance