alter
table
TEST1
add
idnumber(10);
create
sequence
SEQ_ID
minvalue1
maxvalue999999999
start
with
1;
Update
test1
set
id=seq_id.nextval;
commit
;
alter
table
TEST1
add
constraint
PK_TEST1
primary
key
(ID);
select
ID,Name1,CITY
from
TEST1;